11-12-2007
Try FROM_UNIXTIME(unix_timestamp,format)
e.g. 1194873780 = 12th Nov 2007 @ 08:23am, then
FROM_UNIXTIME( 1194873780, '%d %m %Y');
would yield 12 11 2007, You can format it the way you want, for more details about date formatting check DATE_FORMAT(date,format) function in MySQL.
About UNIX timestamp:
The unix time stamp is a way to track time as a running total of seconds. This count starts at the Unix Epoch on January 1st, 1970.
10 More Discussions You Might Find Interesting
1. UNIX and Linux Applications
How would one go about creating 'day' tables based on the timestamp field.
I have some 'import' tables which contains data from various days and would like to spilt that data up into 'days' based on the timestamp field in new tables.
TABLE_IMPORT1
TABLE_IMPORT2
TABLE_IMPORT3
... (2 Replies)
Discussion started by: hazno
2 Replies
2. Shell Programming and Scripting
hi
i need a scrit to convert one date format to another. for example
i have three columns in a file which gets a different format, but lastly i want output
with stadard timestamp as "yyyy-mm-dd hh:mm:ss"
column1 column2 ... (2 Replies)
Discussion started by: dprakash
2 Replies
3. Shell Programming and Scripting
Hi all,
Actually my aim is to call the shell script when ever there is a hit in a mysql table which consist of 3 values. Acter some research I came to know that it is not possible and can achive with timestamp. Can someone please tell me how to read the table timestamp which should done... (3 Replies)
Discussion started by: santhoshvkumar
3 Replies
4. Shell Programming and Scripting
Hi,
I've a file in the following format
1999-APR-8 17:31:06 1500 3 45
1999-APR-8 17:31:15 1500 3 45
1999-APR-8 17:31:25 1500 3 45
1999-APR-8 17:31:30 1500 3 45
1999-APR-8 17:31:55 1500 3 45
1999-APR-8 17:32:06 1500 3 ... (1 Reply)
Discussion started by: vaibhavkorde
1 Replies
5. UNIX for Dummies Questions & Answers
Hi All,
I am new to unix programming. I am trying for a requirement and the requirement goes like this.....
I have a test folder. Which tracks log files. After certain time, the log file is getting overwritten by another file (randomly as the time interval is not periodic). I need to preserve... (2 Replies)
Discussion started by: mailsara
2 Replies
6. Shell Programming and Scripting
I need to be able to identify files with file timestamps greater than a given timestamp.
I am using the following solution, although it appears to compare files at the "seconds" granularity and I need it at the milliseconds. When I tested my solution, it missed files that had timestamps... (3 Replies)
Discussion started by: nkm0brm
3 Replies
7. Shell Programming and Scripting
Hi Friends,
I have the following logfile. Currently time in india is 07/31/2014 12:33:34 and i have the following content in logfile. I want to display only those entries which contain string 'Exception' within last 3 hours. In this case, it would be the last line only
I can get the... (12 Replies)
Discussion started by: srkmish
12 Replies
8. Shell Programming and Scripting
Hello ,
I am working on AIX. I have to convert Unix timestamp to normal timestamp. Below is the file. The Unix timestamp will always be preceded by
EFFECTIVE_TIME as first field as shown and there could be multiple EFFECTIVE_TIME in the file : 3.txt
Contents of... (6 Replies)
Discussion started by: rahul2662
6 Replies
9. Shell Programming and Scripting
So basically I have a log file and each line in this log file starts with a timestamp:
MON DD HH:MM:SS
SEP 15 07:30:01
I need to grep all the lines between last hour timestamp and current timestamp. Then these lines will be moved to a tmp file from which I will grep for particular strings. ... (1 Reply)
Discussion started by: nms
1 Replies
10. Programming
First, I want to thank Neo (LOL) for this post from 2018, Node.js and mysql - ER_ACCESS_DENIED_ERROR
I could not get the Node-RED mysql module to work and searched Google until all my links were purple! I kept getting ER_ACCESS_DENIED_ERROR with the right credentials. Nothing on the web was... (0 Replies)
Discussion started by: Neo
0 Replies
LEARN ABOUT CENTOS
curl_getdate
curl_getdate(3) libcurl Manual curl_getdate(3)
NAME
curl_getdate - Convert a date string to number of seconds since January 1, 1970
SYNOPSIS
#include <curl/curl.h>
time_t curl_getdate(char *datestring, time_t *now );
DESCRIPTION
This function returns the number of seconds since January 1st 1970 in the UTC time zone, for the date and time that the datestring parame-
ter specifies. The now parameter is not used, pass a NULL there.
NOTE: This function was rewritten for the 7.12.2 release and this documentation covers the functionality of the new one. The new one is not
feature-complete with the old one, but most of the formats supported by the new one was supported by the old too.
PARSING DATES AND TIMES
A "date" is a string containing several items separated by whitespace. The order of the items is immaterial. A date string may contain
many flavors of items:
calendar date items
Can be specified several ways. Month names can only be three-letter english abbreviations, numbers can be zero-prefixed and the
year may use 2 or 4 digits. Examples: 06 Nov 1994, 06-Nov-94 and Nov-94 6.
time of the day items
This string specifies the time on a given day. You must specify it with 6 digits with two colons: HH:MM:SS. To not include the time
in a date string, will make the function assume 00:00:00. Example: 18:19:21.
time zone items
Specifies international time zone. There are a few acronyms supported, but in general you should instead use the specific relative
time compared to UTC. Supported formats include: -1200, MST, +0100.
day of the week items
Specifies a day of the week. Days of the week may be spelled out in full (using english): `Sunday', `Monday', etc or they may be
abbreviated to their first three letters. This is usually not info that adds anything.
pure numbers
If a decimal number of the form YYYYMMDD appears, then YYYY is read as the year, MM as the month number and DD as the day of the
month, for the specified calendar date.
EXAMPLES
Sun, 06 Nov 1994 08:49:37 GMT
Sunday, 06-Nov-94 08:49:37 GMT
Sun Nov 6 08:49:37 1994
06 Nov 1994 08:49:37 GMT
06-Nov-94 08:49:37 GMT
Nov 6 08:49:37 1994
06 Nov 1994 08:49:37
06-Nov-94 08:49:37
1994 Nov 6 08:49:37
GMT 08:49:37 06-Nov-94 Sunday
94 6 Nov 08:49:37
1994 Nov 6
06-Nov-94
Sun Nov 6 94
1994.Nov.6
Sun/Nov/6/94/GMT
Sun, 06 Nov 1994 08:49:37 CET
06 Nov 1994 08:49:37 EST
Sun, 12 Sep 2004 15:05:58 -0700
Sat, 11 Sep 2004 21:32:11 +0200
20040912 15:05:58 -0700
20040911 +0200
STANDARDS
This parser was written to handle date formats specified in RFC 822 (including the update in RFC 1123) using time zone name or time zone
delta and RFC 850 (obsoleted by RFC 1036) and ANSI C's asctime() format. These formats are the only ones RFC2616 says HTTP applications may
use.
RETURN VALUE
This function returns -1 when it fails to parse the date string. Otherwise it returns the number of seconds as described.
If the year is larger than 2037 on systems with 32 bit time_t, this function will return 0x7fffffff (since that is the largest possible
signed 32 bit number).
Having a 64 bit time_t is not a guarantee that dates beyond 03:14:07 UTC, January 19, 2038 will work fine. On systems with a 64 bit time_t
but with a crippled mktime(), curl_getdate will return -1 in this case.
REWRITE
The former version of this function was built with yacc and was not only very large, it was also never quite understood and it wasn't pos-
sible to build with non-GNU tools since only GNU Bison could make it thread-safe!
The rewrite was done for 7.12.2. The new one is much smaller and uses simpler code.
libcurl 7.0 12 Aug 2005 curl_getdate(3)