Date to epoch problem


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Date to epoch problem
# 1  
Old 09-18-2009
Question Date to epoch problem

Hi all!

I have a "simple" problem:

I want to convert a date and time string (YYYYMMDDhhmmss) to epoch (unix time) in a shellscript.

I want to use the "date/time" string as an input to the script, eg:
scriptname.sh 20090918231000 and get the epoch format echoed out.

Is there an easy way to do this, I have search for it with no luck.

Thanks in advice

Condmaster
# 2  
Old 09-18-2009
This may help you !

Code:
date --date '20090918 23:10:00' +%s

# 3  
Old 09-18-2009
Quote:
Originally Posted by thegeek
This may help you !

Code:
date --date '20090918 23:10:00' +%s

Thank you for the answer!

But if I use that format I had to convert "my" datetime-string before
converting it to unixtime (probably no issue).

I'm reading those datetime formats from a XML-file with a script
and convert them so they fit in my MySQL db.
# 4  
Old 09-18-2009
I don't understand the last post, but, if the GNU date program is not available,
you could use somethig like this:

Code:
perl -MTime::Local -le'       
    @dt = shift =~ /(\d{2})/g;
    print timelocal $dt[6], $dt[5], $dt[4], $dt[3], $dt[2] - 1,
      ( join "", @dt[ 0 .. 1 ] ) - 1900
  ' <input>

For example:

Code:
% perl -MTime::Local -le'       
@dt = shift =~ /(\d{2})/g;
print timelocal $dt[6], $dt[5], $dt[4], $dt[3], $dt[2] - 1,
  ( join "", @dt[ 0 .. 1 ] ) - 1900
  ' 20090918231000
1253308200

Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Convert a date stored in a variable to epoch date

I am not able to pass date stored in a variable as an argument to date command. I get current date value for from_date and to_date #!/usr/bin/ksh set -x for s in server ; do ssh -T $s <<-EOF from_date="12-Jan-2015 12:02:09" to_date="24-Jan-2015 13:02:09" echo \$from_date echo... (7 Replies)
Discussion started by: raj48
7 Replies

2. Shell Programming and Scripting

Epoch time to produce exact date everytime

so i have to perform a certain task at set times. for instance, i need to run a job at 12:30am every night, and other jobs, i only need to have them run on saturdays. how do i manipulate the date command to give me the epoch equivalence of what 12:30am would be every day? im looking for a... (3 Replies)
Discussion started by: SkySmart
3 Replies

3. Shell Programming and Scripting

Convert epoch time to Julian date

Need assistance in converting an epoch time to Julian date To get epoch perl -e 'use Time::Local; print timelocal(1,5,2,12,10,2008), "\n"' (3 Replies)
Discussion started by: ajayram_arya
3 Replies

4. Shell Programming and Scripting

Turning given date to epoch

i can probably script this in bash, but, i was wondering, does anyone know of a simple way to translate a given time to epoch? date -d@"29/Oct/2013:17:53:11" the user would specify the date: 29/Oct/2013:17:53:11 and the script will simply interpret that to epoch: 1348838383 (this is just... (4 Replies)
Discussion started by: SkySmart
4 Replies

5. OS X (Apple)

Date to epoch problem

Hi all, In terminal when I enter: date -j -f date -j -f "%Y/%m/%d %T" "2011/09/30 13:00:00" +"%s" The output is: When I put 2011/09/30 in var A, and I subsequently enter: date -j -f date -j -f "%Y/%m/%d %T" "${A} 13:00:00" +"%s" The output is: (10 Replies)
Discussion started by: mosthated
10 Replies

6. Programming

Converting a user inputted date to epoch time

Hi all , I need to know how to convert a time stamp entered by the user to be converted to GMT/UTC(epoch time) using mktime() and gmtime() for exapample the input will be put in the form ptm.tm_sec = 0; ptm.tm_min = 59; ptm.tm_hour = 11; ptm.tm_mday = 20;... (2 Replies)
Discussion started by: ada
2 Replies

7. Shell Programming and Scripting

Date conversion from Standard/given format to seconds/epoch

I am trying get time difference of two dates in secs. Initially I want to convert a standard date format to epoch for two dates and then subtract the two epoch dates. Example : date -d "2007-09-01 17:30:40" '+%s' But this gives me below error date: illegal option -- d Usage: date OS: AIX... (6 Replies)
Discussion started by: bpaac
6 Replies

8. Shell Programming and Scripting

Get Formatted Date from Unix Epoch

Could someone please explain how to get a formatted date from the unix epoch (the number of seconds since Jan 1, 1970) For example., If the input is 1297969816, then the output should be 2011-02-17 in YYYY-MM-DD formatted manner. I am using AIX sh shell. Tried date -d and date --date, these... (4 Replies)
Discussion started by: Jesinth Nirmal
4 Replies

9. Shell Programming and Scripting

Need to convert an epoch date to MMDDYYHHmm format

System: HP-UX Kornshell Perl is installed, but not POSIX Hello, I am calculating a future date/time. To do this I take the system date in epoch format and add to it. I now need to take the new epoch date and convert it to MMDDYYHHmm format. Any help with this is greatly appreciated. (4 Replies)
Discussion started by: LetsGoPens
4 Replies

10. Shell Programming and Scripting

Convert date into epoch in Perl on Solaris

Solaris 10 doesn't seem to like me a lot. I am trying to run a simple script to accept date and return epoch of that date: #!/usr/bin/perl -w use strict; use Time::ParseDate; my($date1)="Mon Mar 27 05:54:08 CDT 2009"; chomp $date1; #Convert to seconds since start of epoch my $time1 =... (3 Replies)
Discussion started by: pavanlimo
3 Replies
Login or Register to Ask a Question