Home » SQL & PL/SQL » Client Tools » Show time values for the date fields in SQL+ Worksheet
Show time values for the date fields in SQL+ Worksheet [message #199261] Sun, 22 October 2006 23:34 Go to next message
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.
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 Go to previous messageGo to next message
Littlefoot
Messages: 20895
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>
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 Go to previous message
astaylor
Messages: 6
Registered: October 2006
Junior Member
Cool.

Thanks for your help.
Previous Topic: constant record length in spool file
Next Topic: execute script while logging into isqlplus
Goto Forum:
  


Current Time: Mon Dec 05 19:21:30 CST 2016

Total time taken to generate the page: 0.05202 seconds