Changing table data

• jamesstirling01

  Mr or Mrs. 500

  Points: 596

  More actions

  April 17, 2019 at 1:07 pm

  #3425534

  Hi,

  I have a table name 'Time Reported' and the format of the data is :

  1899-12-30 09:12:32.000

  There are 29602 rows of data, this was imported from a old Access database i would like to run a SQL query to remove the 1899-12-30 & the .000 and leave the 09:12:32

  Can anyone assist with a SQL query that will achive this.

  Cheers James

• John Mitchell-245523

  SSC Guru

  Points: 148809

  More actions

  April 17, 2019 at 1:24 pm

  #3425803

  DECLARE @TimeReported datetime = '1899-12-30 09:12:32.000';
  DECLARE @NewTime time;
  SET @NewTime = CAST(@TimeReported AS time);
  SELECT @NewTime;

  John