SQL Query

[suketh]

Hi, please can anyone let me know the date formats in sql server for this query. my table structure is" PDate PMonth PYear 10 05 2007 03 05 2004 12 10 2007 o1 12 2005 now i have to retrieve the records based on some specified dates. for example, i want the records which matches "12/10/2007" i know how to write the code for these 3 columns to format (mm/dd/yyyy)using C# & vb.Net but i want to know how to write using Tsql Thanks, Suketh

[Harini N K]

Hi Use the date functions like Month(), Day() and Year() to get month,date and year. Based on these functions you can filter records. For example Month(DateColumn) will display month of the given datecolumn Hope you got it... :)

Harini

[shally_79]

use this query select * from t1 where pdate=day('10/12/2007') and pmonth=month('10/12/2007') and pyear=year('10/12/2007') Note= you should format the date as 'MM/dd/yyyy' date function returns day('10/12/2007') as 12

shally

[raj code]

set dateformat dmy Go select * from Table where Pdate=select Datepart(Day,'12/10/2007') and PMonth=Datepart(Month,'12/10/2007') and PYear=Datepart(Year,'12/10/2007')