Home » RDBMS Server » Server Administration » Change format of date in SQL View
Change format of date in SQL View [message #371316] Tue, 03 October 2000 04:48 Go to next message
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

Report message to a moderator

Re: Change format of date in SQL View [message #371319 is a reply to message #371316] Tue, 03 October 2000 08:24 Go to previous message
Bala
Messages: 205
Registered: November 1999
Senior Member
Hi
While creating the view
use to_char(date_feild, 'MM/DD/YYYY') as date

Thanks
Bala

Report message to a moderator

Previous Topic: query
Next Topic: Substitution Variable in Select Statement (HELP)
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Apr 25 10:51:21 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.