Home » RDBMS Server » Server Administration » Re: sql primer, date question
Re: sql primer, date question [message #372685] Sat, 03 March 2001 01:31
ramu
Messages: 82
Registered: February 2001
Member
Try this..

ALTER SESSION SET NLS_DATE_FORMAT = 'DD-MM-YYYY:HH:MI:SS'

And

SELECT Date_field FROM table_name;

Report message to a moderator

Previous Topic: Update on LONG Column
Next Topic: Re: sql primer, date question
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun Jun 30 16:13:42 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.