Home » SQL & PL/SQL » SQL & PL/SQL » NUMTODSINTERVAL bring back same dates (oracle 91)
NUMTODSINTERVAL bring back same dates [message #297200] Wed, 30 January 2008 10:51 Go to next message
jvonhendy
Messages: 1
Registered: January 2008
Location: GREENVILLE
Junior Member
I am trying to conver a Unix date and time to a date. I found in an earlier post to use the NUMTODSINTERVAL function.
All the dates comback with the same date. Does anybody have any suggestions?

,TO_DATE('19390101000000','YYYYMMDDHH24MISS')
+ NUMTOYMINTERVAL(AD_DATA.LAST_LOGIN , 'month')


thanks,

Jerry
Re: NUMTODSINTERVAL bring back same dates [message #297203 is a reply to message #297200] Wed, 30 January 2008 11:24 Go to previous message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
1/ Unix time starts in 1970
2/ What does LAST_LOGIN contains?

Regards
Michel
Previous Topic: ORA-01410 Invalid Rowid
Next Topic: new in sql need help with date datatype and java
Goto Forum:
  


Current Time: Sat Dec 03 16:15:32 CST 2016

Total time taken to generate the page: 0.26358 seconds