Hi all,
Could you please let me know how can I do a Date to Timestamp conversion. I have a job where I have a date format and need to convert to Time stamp format which is output format. I know we can do timestamp to date using TimestampToDate function. But iam not sure how we can do this. i would like to put zero's in time portion. Please help me out.
Regards
Naresh
date to timestamp
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 3
- Joined: Tue Apr 01, 2008 7:15 am
- Location: Hyderabad
Re: date to timestamp
Hi,
if you need default time to be added to the date part then you can go for following conversion.
StringToTimestamp(DateToString(DSLink2.da,"%yyyy-%mm-%dd") : ' 00:00:00',"%yyyy-%mm-%dd %hh:%nn:%ss")
thanks.
if you need default time to be added to the date part then you can go for following conversion.
StringToTimestamp(DateToString(DSLink2.da,"%yyyy-%mm-%dd") : ' 00:00:00',"%yyyy-%mm-%dd %hh:%nn:%ss")
thanks.
Soumyaranjan Mohaptra
Re: date to timestamp
Use Timestamp data type and use function in transformer stage DatetoTimestamp(ColumnName)
Regards,
Sampath
Sampath