OraFAQ Forum: Client Tools » Show time values for the date fields in SQL+ Worksheet

Home » Other » Client Tools » Show time values for the date fields in SQL+ Worksheet

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

Show time values for the date fields in SQL+ Worksheet [message #199261]

Sun, 22 October 2006 23:34

astaylor
Messages: 6
Registered: October 2006

Junior Member

Is it possible to see date_time values for the Date fields in SQL+ Worksheet.
It looks as if the time portion is truncated.

Thanks.

Report message to a moderator

Re: Show time values for the date fields in SQL+ Worksheet [message #199271 is a reply to message #199261]

Mon, 23 October 2006 01:30

Littlefoot
Messages: 21807
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

This would be one way to do it:

SQL> select to_char(sysdate, 'dd.mm.yyyy hh24:mi:ss') today from dual;

TODAY
-------------------
23.10.2006 08:28:47

SQL>

And here's another one:

SQL> alter session set nls_date_format = 'dd.mm.yyyy hh24:mi:ss';

Session altered.

SQL> select sysdate from dual;

SYSDATE
-------------------
23.10.2006 08:29:39

SQL>

Report message to a moderator

Re: Show time values for the date fields in SQL+ Worksheet [message #199333 is a reply to message #199271]

Mon, 23 October 2006 11:28

astaylor
Messages: 6
Registered: October 2006

Junior Member

Cool.

Thanks for your help.

Report message to a moderator

Previous Topic:	constant record length in spool file
Next Topic:	execute script while logging into isqlplus

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 19 13:10:42 CDT 2024