Home » SQL & PL/SQL » SQL & PL/SQL » how can I get the full date data?
how can I get the full date data? [message #39246] Sun, 30 June 2002 22:28 Go to next message
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 #39247 is a reply to message #39246] Sun, 30 June 2002 23:03 Go to previous message
Saga
Messages: 51
Registered: April 2002
Member
Use TO_CHAR(column_name, 'DD-MM-YYYY HH24:MI:SS').
Output will depend on the value stored in the database.

Report message to a moderator

Previous Topic: URGENT - ORA-04091 table name is mutating, trigger/function may not see it
Next Topic: Re: ALTER USER...... ADMIN OPTION
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Apr 25 07:44:29 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.