Setting a Derivation to '0001-01-01'

ScottDun · Post by **ScottDun** » Mon Dec 21, 2015 2:41 pm

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!

chulett · Post by **chulett** » Mon Dec 21, 2015 3:12 pm

StringToTimestamp. And you'll need a time as well, even if it's all zeroes.

ScottDun · Post by **ScottDun** » Mon Dec 21, 2015 3:25 pm

StringToTimestamp(0001-01-01 00:00:00,[%"%yyyy-%mm-%dd %hh:%nn:%ss"%])

I input this and it isn't working.

ScottDun · Post by **ScottDun** » Mon Dec 21, 2015 3:29 pm

I also took out the '%' in front and back of the quotes....

StringToTimestamp(0001-01-01 00:00:00,["%yyyy-%mm-%dd %hh:%nn:%ss"])

samyamkrishna · Post by **samyamkrishna** » Mon Dec 21, 2015 3:37 pm

Try
StringToTimestamp("0001-01-01 00:00:00","%yyyy-%mm-%dd %hh:%nn:%ss")

chulett · Post by **chulett** » Mon Dec 21, 2015 3:38 pm

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.