Change format of date in SQL View [message #371316] |
Tue, 03 October 2000 04:48 |
jaf
Messages: 2 Registered: October 2000
|
Junior Member |
|
|
I am creating a SQL View based on several tables, but I'm having some problems getting the output I need.
One of the fields is a date field, which returns data in the format dd/mm/yyyy hh:mm:ss. I need the View to simply return the dd/mm/yyyy value as I am not interested in the time part of the date.
I am fairly new to SQL (to put it mildly!) and any assistance will be greatly appreciated.
PS: Can you please reply to my email address as I check that on a regular basis.
Thanks - JAF
|
|
|
|