how to ignore time and get only date in a query?

[nirmalsingh]

in a datetime field, i need only date and not time. for eg: 12/06/2006 12:12:00
i need the result as 12/12/2006. how should i write query to get this resultant?

[devikacs]

in a datetime field, i need only date and not time. for eg: 12/06/2006 12:12:00
i need the result as 12/12/2006. how should i write query to get this resultant?

you can use datepart to retrive the required part of the date from datetime

[siva538]

in a datetime field, i need only date and not time. for eg: 12/06/2006 12:12:00
i need the result as 12/12/2006. how should i write query to get this resultant?

Try this

SELECT CONVERT(VARCHAR(10),GETDATE(),101)

Regds,
Sivakumar

[mandy1]

in a datetime field, i need only date and not time. for eg: 12/06/2006 12:12:00
i need the result as 12/12/2006. how should i write query to get this resultant?

Hello to every one. Myself Mandeep and new to all of u.

u can use following format to extract date, or date+time
suppose your date and time are stored in DTime field. then u can use following.

Format(DTime, "General Date") Example date+time
Format(DTime, "Long Date") Example sunday,december 02,2006
Format(DTime, "Medium Date") Example same as long date
Format(DTime, "Short Date") Example 12/02/2006

Remember: DTime is your field in which date and time is stored together.

Real Example

Select format(DTime, "Short date") AS Date_Result From XYZ;

Mandy(Mandeep)