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)