GetDate() default value for datetime fields


GetDate() default value for datetime fields
View
Options
Author
Message
Chris Crabtree
Chris Crabtree
Chris Crabtree
posted 18 Years Ago
StrataFrame User (141 reputation)StrataFrame User (141 reputation)StrataFrame User (141 reputation)StrataFrame User (141 reputation)StrataFrame User (141 reputation)StrataFrame User (141 reputation)StrataFrame User (141 reputation)StrataFrame User (141 reputation)StrataFrame User (141 reputation)
Group: Forum Members
Posts: 57, Visits: 107
Not sure where the root of this issue lies, but specifying GetDate() as the default value for a datetime field in DDT results in the 1/1/1800 value when deployed against SQL Server.

Not a big deal, but it would be convenient if it worked. Also an improvement would be to simply remove the option if it's not going to work so I quit trying it. Smile

Thanks!

Reply Like 1
GO

Merge Selected

Merge into selected topic...



Merge into merge target...



Merge into a specific topic ID...



Submit

Threaded View
Threaded View
GetDate() default value for datetime fields
Chris Crabtree - 18 Years Ago
     The problem is that new records are specified with default values when...
StrataFrame Team - 18 Years Ago

Similar Topics

Post Quoted Reply
Reading This Topic

Powered by InstantForum 2017-1 Final © 2024
Execution: 0.000. 2 queries. Compression Enabled.

Login

Explore
Messages
Mentions
Search