quering date data type

• eduardovwc

  SSC Enthusiast

  Points: 112

  More actions

  May 30, 2005 at 4:58 am

  #69093

  Hi Guys?

  Is it possible to save only the date in a datetime  data type column of a table?

  Reason being that , when i use the getdate() to insert  a date value in a table it inserts the date ant the time eg: '2005/01/01 00:00:00'.

  and when i query the date eg: SELECT * FROM TABLENAME WHERE DATE = '2005/01/01' IT RETURNS NOTHING.

  THE SAME HAPPENS WHEN I USER THE CONVERT OPTION

  eg: CONVERT(DATETIME, '2005/01/01')

   

  PLEASE HELP !

  Thank You!

   

  Eduardo vwc

  KBS.com

   

• Frank Kalis

  SSC Guru

  Points: 111183

  More actions

  May 30, 2005 at 5:29 am

  #561672

  See if this helps: http://www.sql-server-performance.com/fk_datetime.asp

  --
  Frank Kalis
  Microsoft SQL Server MVP
  Webmaster: http://www.insidesql.org/blogs
  My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

• vadba

  SSChampion

  Points: 11133

  More actions

  May 31, 2005 at 7:55 am

  #561879

  Here's one way. Instead of GetDate(), store this:

  CONVERT(datetime, CONVERT(varchar(8), GetDate(), 112))

• Ragesh Chavarattil

  Old Hand

  Points: 328

  More actions

  July 9, 2005 at 9:28 am

  #572702

  You can use : SELECT * FROM TABLENAME WHERE DATE = '01 Jan 2005'

  it will return satisifing records. But while inserting/updating from client programs using native languages, you should take care. Always better to convert into datetime from yyyymmdd format.

  Regards,

  Ragesh Chavarattil