Seperating Date part from a datetime field

ctranjith · October 23rd, 2004, 11:56 AM

Sir
How can I seperate date part(only date) field contain both date and time using sql server query
is there is any way like cast or convert is there to do that
i can do it by using datepart function but I did't think is so speedy Iam searching for seperate function for that

Can U help me

jemacc · October 23rd, 2004, 04:16 PM

you can use convert

Code:

select convert(varchar (10),getdate(),101)

Jaime E. Maccou
Applications Analyst

ctranjith · October 25th, 2004, 06:42 AM

thank U