Home » RDBMS Server » Server Administration » Re: sql primer, date question
Re: sql primer, date question [message #372686] Sat, 03 March 2001 01:32
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: Re: sql primer, date question
Next Topic: Re: help
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue Jun 18 08:46:11 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.