Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Time Stamp calculations

Time Stamp calculations

From: Joshua Goodstein <awing_pilot_at_yahoo.com>
Date: 4 Feb 2002 07:11:49 -0800
Message-ID: <924a90f8.0202040711.5c955ad1@posting.google.com>


I am trying to create a procedure that changes the sysdate in Oracle to the UNIX time to store in a field. aka i execute the function/proocedure and it will insert the seconds since Jan 1 1970 in the feild. IS there a procedure that does this already? Thanks in advance

I want sysdate to unix date, not unix date to sysdate.

thanks in advance

J Received on Mon Feb 04 2002 - 09:11:49 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US