string to timestamp conversion

marpadga18 · Post by **marpadga18** » Thu Sep 20, 2012 5:28 am

HI All,
my source has a varchar column DATE with following data :
8/3/2012 12:00:00 AM

My target should be like this
2012-08-03 00:00:00

I tried with date conversions but not getting exact output any ideas really appreciated Thanks M

ray.wurlod · Post by **ray.wurlod** » Thu Sep 20, 2012 5:45 am

How about you show us what you tried, and tell us in what way you are not "getting exact output"?

marpadga18 · Post by **marpadga18** » Thu Sep 20, 2012 5:47 am

StringToTimestamp(lnk_src_exl_onbase.DATE,"%(m,s)/%(d,s)/%yyyy%(H,s):%nn:%ss%aa")

chulett · Post by **chulett** » Thu Sep 20, 2012 7:41 am

So, that gets it to a timestamp. What is your target's data type? What output are you currently getting? If you need a particular format, convert it back to a string.