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
Populate date as Timestamp
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 153
- Joined: Thu May 11, 2006 1:52 am
- Location: Bangalore
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.