Populate date as Timestamp

sumesh.abraham · Post by **sumesh.abraham** » Wed Nov 05, 2008 3:10 am

Hi All,

I want to populate todays's date as '11/05/2008 12:00:00'. How can I do other than hardcoding as
OConv(@DATE,"D-YMD"):'12:00:00'

Thanks,
Sumesh

ray.wurlod · Post by **ray.wurlod** » Wed Nov 05, 2008 7:12 am

Why do you want to do "other than"? It's a perfectly valid approach. Anyway, one "other than" approach is to decompose your source date using substring techniques then re-assemble it with concatenation, adding the time portion.

chulett · Post by **chulett** » Wed Nov 05, 2008 7:38 am

That's not "hard-coding". What is your target - a database? The format will probably need to be slightly different if that's the case.