How to Convert an Oracle Date to a Unix Timestamp
The Oracle Database is enterprise database software that complies with the SQL standard for interacting with a database. Oracle stores date information in the form of month, day, year, hour, minute and second. Unix time stamps are numbers that represent the number of seconds that have passed since midnight on January 1, 1970. If your Oracle Database has a date field, you can convert any date to a Unix time stamp using a conversion command from the Oracle Database Query software.
Other People Are Reading
Instructions
-
-
1
Click "Start" and type "Oracle Database Query." Press "Enter."
-
2
Double-click the database server you would like to use. Provide your username and password when prompted.
-
-
3
Click the table that contains your information, then right-click the field under the formatted "Date" column.
-
4
Click "Options" on the top of the screen, and then select "Interpret." A menu that has the "Get Unix Time" option appears. Click the "Get Unix Time" option to retrieve the date in Unix time.
-
1
