TimestampTodate

Ush · Post by **Ush** » Thu Feb 07, 2008 11:09 pm

Hi
I have datetime column which can be either in this format :
'21-01-2008 12:00:00' or '21-01-2008'.

I have to convert timestamp to date:
TimestampToDate function accepts only timestamp as input.

Please let me know as how to convert the same.

Thanks

ray.wurlod · Post by **ray.wurlod** » Fri Feb 08, 2008 12:03 am

Make sure that your datetime column is never in the second format.

Maveric · Post by **Maveric** » Fri Feb 08, 2008 12:27 am

Read the data as varchar and check the length. If it is 10 then you can directly map it to your output field. If it is greater than 10 then use field() with space as the delimiter and get the first half.

dspxlearn · Post by **dspxlearn** » Fri Feb 08, 2008 12:39 pm

If you are pulling the field from the database, just use Trunc(Field) which gives you only the date.
Pull that through the transformer without doing anything.

Or as Maveric said,
Read the data as varchar and check if the length is more than 10. If it is more than 10,

Code: Select all

Left(Field,10)

If you want to convert it back to date- use StringToDate()