date format

[Hm786]

Hi,

I have a question, in my sybase sql i need to show only the date not the time. Is there a date format function which does this one. Please help me.


Thanks,
Hamida

 

[PHV]

How is your sybase sql related to msaccess ?
The access answer:
Int([your DateTime field])

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[Hm786]

I just want to strip the time from this d_start_date field in my sql which runs against sybase database. I am grouping on this field which gives me extra rows with the time.

Thanks,
Hamida