OraFAQ Forum: SQL & PL/SQL » how can I get the full date data?

Home » SQL & PL/SQL » SQL & PL/SQL » how can I get the full date data?

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

how can I get the full date data? [message #39249]

Sun, 30 June 2002 23:53

irixwang
Messages: 2
Registered: June 2002

Junior Member

In the table ,there is a column which datatype is date,I have insert the value,such as '02-20-2002 14:30:30',when I use the SELECT commnand to get the date value,it display '02-20-02',how can I get the others,include the hour,minute and second?

Report message to a moderator

Re: how can I get the full date data? [message #39253 is a reply to message #39249]

Mon, 01 July 2002 07:05

Balaji
Messages: 102
Registered: October 2000

Senior Member

try this,

select to_char(date1,'DD-MON-YYYY HH24:MI:SS')FROM
TABLE1

rgds
Balaji

Report message to a moderator

Re: how can I get the full date data? [message #39312 is a reply to message #39249]

Fri, 05 July 2002 05:17

Depa
Messages: 30
Registered: June 2002

Member

hai in sqlplus if you want to see the whole format

give

alter session set nls_date_format='dd-mon-yyyy hh24:mi:ss';

But this will be active for that session only.

Report message to a moderator

Previous Topic:	Re: ORA-12560: TNS:protocol adapter error
Next Topic:	Conversion from char to date and compare

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 25 10:54:13 CDT 2024