I need timestamp in below format
Code: Select all
MM/DD/YYYY HH:MM:SS AM/PM
Code: Select all
OCONV(DATE(),"D/MDY[2,2,4]") :" " : UPCASE(OCONV(TIME(),"MTHS"))
Eg:-01/01/2010 12:12:12AM --> 01/01/2010 12:12:12 AM
Thanks
Moderators: chulett, rschirm, roy
Code: Select all
MM/DD/YYYY HH:MM:SS AM/PM
Code: Select all
OCONV(DATE(),"D/MDY[2,2,4]") :" " : UPCASE(OCONV(TIME(),"MTHS"))
Code: Select all
OCONV(DATE(),"D/MDY[2,2,4]") :" " : OCONV(TIME(),"MTS")
Code: Select all
svTimestamp <-- Oconv(Date(),"D/MDY[2,2,4]" : " " : Upcase(Oconv(Time(),"MTHS"))
Left(svTimestamp,19) : " " : Right(svTimestamp.2)