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: 63915
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

alter session set nls_date_format...

Previous Topic: "function in package return array used in SQL" error ..
Next Topic: what is the difference between database & schema??
Goto Forum:

Current Time: Mon Oct 24 09:33:39 CDT 2016

Total time taken to generate the page: 0.10304 seconds