Hi,
I want to deafult a Timestamp field to ''12/31/9999 00:00:00"
How would I do this in a Transformer stage?
I tried:
StringToTimestamp('12/31/9999 00:00:00',"mm/dd/yyyy hh:nn:ss")
TimestampFromDateTime(StringToDate('12/31/9999',"mm/dd/yyyy"), StringToTime('00:00:00',"%hh:%nn:%ss"))
Both did not work correctly. A fatal error was thrown.
How to resolve this issue?
Thanks in advance.
Deepa
How to default a Timestamp Field?
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 95
- Joined: Thu Sep 24, 2009 12:15 am
- Location: India
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 95
- Joined: Thu Sep 24, 2009 12:15 am
- Location: India