Home » SQL & PL/SQL » SQL & PL/SQL » how to retrive this?
how to retrive this? [message #226645] Mon, 26 March 2007 01:35 Go to next message
Messages: 74
Registered: March 2007
Location: Pune
If i have a column with datatype date.I have inserted time along
with the date.Then i have to display only date for the whole session not for current query.
Please tell me how to achieve that?
Re: how to retrive this? [message #226652 is a reply to message #226645] Mon, 26 March 2007 02:11 Go to previous message
Michel Cadot
Messages: 65144
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

alter session set nls_date_format...

Previous Topic: what is the difference between database & schema??
Next Topic: No logging?
Goto Forum:

Current Time: Sun Aug 20 18:16:56 CDT 2017

Total time taken to generate the page: 0.05642 seconds