Hi,
I am trying to default a column, with a Timestamp datatype, to '0001-01-01'. Is there a function that will do that? I typed in the 0001-01-01 and all that was returned were stars because I did not have a function. Any help would be great. Thanks!
Setting a Derivation to '0001-01-01'
Moderators: chulett, rschirm, roy
Setting a Derivation to '0001-01-01'
SCOTTDun
-
- Premium Member
- Posts: 258
- Joined: Tue Jul 04, 2006 10:35 pm
- Location: Toronto
You need quotes around your string and there's no square brackets needed.
Also there's no need to quote everything all the time, rather than 'Reply with quote' simply use the Reply to topic link. Save the quoting for when it makes sense.
![Exclamation :!:](./images/smilies/icon_exclaim.gif)
Last edited by chulett on Mon Dec 21, 2015 3:40 pm, edited 1 time in total.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers