Since you did not provide feedback I tried to figure it out myself. The hex string is the seconds from the UNIX epoch and translates to Sat 17 February 2007 16:53:10 UTC
Hi,
I need to select the entries between two dates from an Oracle db. The Oracle db has a column with Unix timestamps. I use the following querry, but it doesnt seem to be working as desired.
select count(*) from reporter_status where to_char(FIRSTOCCURRENCE, 'mm-dd-yy') between ('08-07-06')... (1 Reply)
Hi
I have a file which has ascii , binary, binary decimal coded,decimal & hexadecimal data with lot of special characters (like öƒ.ƒ.„İİ¡Š·œƒ.„İİ¡Š· ) in it. I want to standardize the file into ASCII format & later use that as source .
Can any one suggest a way a logic to convert such... (5 Replies)
Dear Experts,
I need your help to convert a unix date and time format number in to readable format like dd/mm/yyyy .
I have a text file of more than 10,000 records and it is like
NAME DATE1 COUNTRY DATE2
ABD 1223580395699 USA 1223580395699... (3 Replies)
How would I convert a unix timestamp such as "1232144092" to a readable date such as "1/16/2009 10:14:28 PM" ?
I thought I could use date, but I don't think so now.. Any help would be great!! (4 Replies)
In Unix/Ksh, when I try to look inside a file it says that the file may be a binary file and if I want to see it anyway. When i say 'yes', it shows me the content filled with unreadable symbols (looks like binary). Is there a command that I can run from the Unix prompt to convert/translate that... (3 Replies)
Hi,
I am having couple of files which i used to copy from windows to Linux, so now in case of text files (CTRL^M) appears at end of line. I know i can convert this windows format file to unix format file by running dos2unix.
My requirement here is that i want to do it automatically using a... (5 Replies)
Hi,
I am new to shell scripting and exploring it , I have developed few sample shell script but I have developed them on windows xp notepad and then saving them on folder and then testing them on cywgin and running perfectly...but these scripts are in dos format and I want to convert them in unix... (1 Reply)
I am trying to create a script that will take epoch (input from command line) and convert it into a readable format in bash/shell
---------- Post updated at 08:03 PM ---------- Previous update was at 07:59 PM ----------
#!bin/bash
read -p "Please enter a number to represent epoch time:"... (9 Replies)
Hello I have a file : file1.txt with the below contents :
237176 test1 test2 1442149024
237138 test3 test4 1442121300
237171 test5 test7 1442112823
237145 test9 test10 1442109600
In the above file fourth field represents the timestamp in Unix format.
I found a command which converts... (6 Replies)
Discussion started by: rahul2662
6 Replies
LEARN ABOUT POSIX
gmtime_r
GMTIME(P) POSIX Programmer's Manual GMTIME(P)
NAME
gmtime, gmtime_r - convert a time value to a broken-down UTC time
SYNOPSIS
#include <time.h>
struct tm *gmtime(const time_t *timer);
struct tm *gmtime_r(const time_t *restrict timer,
struct tm *restrict result);
DESCRIPTION
For gmtime(): The functionality described on this reference page is aligned with the ISO C standard. Any conflict between the require-
ments described here and the ISO C standard is unintentional. This volume of IEEE Std 1003.1-2001 defers to the ISO C standard.
The gmtime() function shall convert the time in seconds since the Epoch pointed to by timer into a broken-down time, expressed as Coordi-
nated Universal Time (UTC).
The relationship between a time in seconds since the Epoch used as an argument to gmtime() and the tm structure (defined in the <time.h>
header) is that the result shall be as specified in the expression given in the definition of seconds since the Epoch (see the Base Defini-
tions volume of IEEE Std 1003.1-2001, Section 4.14, Seconds Since the Epoch), where the names in the structure and in the expression corre-
spond.
The same relationship shall apply for gmtime_r().
The gmtime() function need not be reentrant. A function that is not required to be reentrant is not required to be thread-safe.
The asctime(), ctime(), gmtime(), and localtime() functions shall return values in one of two static objects: a broken-down time structure
and an array of type char. Execution of any of the functions may overwrite the information returned in either of these objects by any of
the other functions.
The gmtime_r() function shall convert the time in seconds since the Epoch pointed to by timer into a broken-down time expressed as Coordi-
nated Universal Time (UTC). The broken-down time is stored in the structure referred to by result. The gmtime_r() function shall also
return the address of the same structure.
RETURN VALUE
Upon successful completion, the gmtime() function shall return a pointer to a struct tm. If an error is detected, gmtime() shall return a
null pointer and set errno to indicate the error.
Upon successful completion, gmtime_r() shall return the address of the structure pointed to by the argument result. If an error is
detected, gmtime_r() shall return a null pointer.
ERRORS
The gmtime() function shall fail if:
EOVERFLOW
The result cannot be represented.
The following sections are informative.
EXAMPLES
None.
APPLICATION USAGE
The gmtime_r() function is thread-safe and returns values in a user-supplied buffer instead of possibly using a static data area that may
be overwritten by each call.
RATIONALE
None.
FUTURE DIRECTIONS
None.
SEE ALSO
asctime() , clock() , ctime() , difftime() , localtime() , mktime() , strftime() , strptime() , time() , utime() , the Base Definitions
volume of IEEE Std 1003.1-2001, <time.h>
COPYRIGHT
Portions of this text are reprinted and reproduced in electronic form from IEEE Std 1003.1, 2003 Edition, Standard for Information Technol-
ogy -- Portable Operating System Interface (POSIX), The Open Group Base Specifications Issue 6, Copyright (C) 2001-2003 by the Institute of
Electrical and Electronics Engineers, Inc and The Open Group. In the event of any discrepancy between this version and the original IEEE
and The Open Group Standard, the original IEEE and The Open Group Standard is the referee document. The original Standard can be obtained
online at http://www.opengroup.org/unix/online.html .
IEEE /The Open Group 2003 GMTIME(P)