I have this saved-up some time ago. Hope it helps ..
----------------------------------------
Here is the information on how to convert from EPOCH time (time in seconds since 1/1/1970) to our HUMAN time.
There is also an SQL select statement example showing how to convert from EPOCh to HUMAN time included below.
In addition, there is code included that shows how to print the current EPOCH time.
1. Conversion from EPOCH to HUMAN time:
The following is the source code in 'C':
#include
main(argc, argv)
int argc;
char **argv;
{
time_t foo;
foo = atoi(argv[1]);
printf("%s",ctime(&foo));
}
1a. Create a vi file (with extension .c) that includes the above lines.
For example: vi time.c
From the command line type the following:
cc (filename)
For example: cc time.c
This should create an a.out file in same directory.
1b. Simply run the command:
For example:
./a.out 913097859 <<<---digits you want converted
Your output will look like:
Tue Dec 8 00:17:39 1998
2. The SQL 'select' statement can be used to convert ITO Oracle EPOCH fields to human time:
select
TO_DATE(TRUNC(creation_time/ 86400) + 2440588, 'J'),
TO_CHAR(TO_DATE(MOD(creation_time, 86400), 'SSSSS'),'HH24:MI:SS')
from opc_op.opc_act_messages
where node_id = '';
3. Here is source code in 'C' to print current time in EPOCH time:
#include
main()
{
printf("%ld\n",time(NULL));
}
3a. Create a vi file (with extension .c) that include the above lines.
For example: vi time.c
From the command line type the following:
cc (filename)
For example: cc time.c
This should create an a.out file in same directory.
3b. Simply run the command:
For example:
./a.out
Remember EPOCH fields will expire (reach their limit at) year 2037
