|
|
|
|
|
Re: display date by increment of one minute [message #422167 is a reply to message #422082] |
Mon, 14 September 2009 22:59 |
|
Kevin Meade
Messages: 2103 Registered: December 1999 Location: Connecticut USA
|
Senior Member |
|
|
Guess I don't understand the question. Oracle normal dates are already at a granularity of a second. Let me supply this:
alter session set nls_date_format = 'dd-mon-rrrr hh24:mi:ss';
1 select
2 sysdate normal_granularity
3 ,trunc(sysdate,'mi') minutes_granularity
4 ,trunc(sysdate,'hh24') hours_granularity
5 ,trunc(sysdate,'dd') days_granularity
6 ,trunc(sysdate,'mm') months_granularity
7 ,trunc(sysdate,'rrrr') years_granularity
8* from dual
SQL> /
NORMAL_GRANULARITY MINUTES_GRANULARITY HOURS_GRANULARITY DAYS_GRANULARITY MONTHS_GRANULARITY YEARS_GRANULARITY
-------------------- -------------------- -------------------- -------------------- -------------------- --------------------
14-sep-2009 23:57:44 14-sep-2009 23:57:00 14-sep-2009 23:00:00 14-sep-2009 00:00:00 01-sep-2009 00:00:00 01-jan-2009 00:00:00
SQL>
Kevin
|
|
|