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

  • 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