Logo

SQL Script

EPOC Date

 Tested on Oracle 8.1 Tested on Oracle 8.0 Tested on Oracle 7

Updated : 06-June-2000
Version : 1.0

Description

This converts a UNIX epoc date into a normal date. This is useful for third party applications which store dates as EPOC dates in the database.

Parameters

EPOC Number

SQL Source

SELECT  to_char(
            TO_DATE('01-JAN-1970','DD-MON-YYYY') + &epoch_num/86400 
	,'dd-mon-yyyy hh24:mi:ss') normal_date
FROM dual;

Return to Index of SQL Scripts

Home | Company Profile | Services | Contact Us | SQL scripts and tips | Quiz
Legal

Logo