Date Conversion

• TST1

  SSCommitted

  Points: 1798

  More actions

  October 4, 2011 at 5:21 am

  #258478

  Hi,

  I run the following query with the following output

  select * from table1 where db = 'a' and time >= '01-01-2011'?

  2011-02-17 12:19:04.420

  2011-02-17 12:19:09.200

  2011-06-21 11:36:39.957

  My problem is how can I get this to display as UK dd-mm-yy without the time?

  Thanks

• J Livingston SQL

  SSC Guru

  Points: 51550

  More actions

  October 4, 2011 at 5:43 am

  #1390069

  SELECT COL1,COL2... convert(varchar,YOUR_DATE_COLUMN, 3)

  ________________________________________________________________
  you can lead a user to data....but you cannot make them think
  and remember....every day is a school day

• Ronald H

  SSCarpal Tunnel

  Points: 4053

  More actions

  October 4, 2011 at 5:50 am

  #1390073

  SELECT COL1,COL2... convert(varchar,YOUR_DATE_COLUMN, 3) leads to dd/mm/yy, while you mentioned dd-mm-yyyy that should be

  SELECT COL1,COL2... convert(varchar,YOUR_DATE_COLUMN, 105)

  Ronald HensbergenHelp us, help yourself... Post data so we can read and use it: http://www.sqlservercentral.com/articles/Best+Practices/61537/-------------------------------------------------------------------------2+2=5 for significant large values of 2

• TST1

  SSCommitted

  Points: 1798

  More actions

  October 4, 2011 at 6:01 am

  #1390077

  Thanks