Home Forums SQL Server 2008 SQL Server Newbies Help needed in converting an int datatype to MM/DD/YYYY and converting another int to HH:MM PM RE: Help needed in converting an int datatype to MM/DD/YYYY and converting another int to HH:MM PM
hmbtx
SSCarpal Tunnel
Points: 4664
More actions
August 27, 2012 at 2:44 pm
#1530522
Lowell:
Thank you for the revised script.
However, I was trying to return the two separate columns.
The next_run_date as MM/DD/YYYY
and the next_run_time as HH:MM AM/PM.
GSuared:
Thank you for the explanation.
Howard