I am trying to insert records into an existing table that has a specific format for dates and times in the existing records:
Date format (Last_Chg_Dt) is '2005-09-16 00:00:00.0000'
Time format (Last_Chg_Time) is '1900-01-01 12:26:16.060'
Using GetDate(), I cannot find a format to replicate these. They return either a date or a time or both, but not in the format as shown above!
Any ideas?
Date format (Last_Chg_Dt) is '2005-09-16 00:00:00.0000'
Time format (Last_Chg_Time) is '1900-01-01 12:26:16.060'
Using GetDate(), I cannot find a format to replicate these. They return either a date or a time or both, but not in the format as shown above!
Any ideas?