SQL Script EPOC Date

Updated: 06-Jun-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

REM Copyright (C) Think Forward.com 1998- 2005. All rights reserved. 


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

Site Map

General Information : Home | Company Profile | Contact Us | Legal
Database Support : Proactive Support | Pay Per Incident Support
Expert Services : High Availability | Creative Solutions | Training
Build Services : Oracle Installations | Revive your Oracle Setup | Low Cost Development
Free Oracle Resources: DBA Scripts | Oracle Links