Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Date command format
Top Forums Shell Programming and Scripting Date command format Post 302874075 by Don Cragun on Thursday 14th of November 2013 04:05:40 AM
Old 11-14-2013
Quote:
Originally Posted by Kevin Tivoli
Hi,

I need to convert a date format "August 12, 2013 9:40:00 PM CDT" in to DD/MM formant

For example ..I am using ...
Code:
date -d "January10, 2013 04:05:00 AM CST" +%m/%d

which gives me...
Code:
01/10

However, when i'am using it against every month it is throwing errors on some months as below....
Code:
for i in January February March April May June July August September October November December ; do date -d "$i 10, 2013 04:05:00 AM CST" +%m/%d; done
01/10
02/10
date: invalid date `March 10, 2013 04:05:00 AM CST'
date: invalid date `April 10, 2013 04:05:00 AM CST'
date: invalid date `May 10, 2013 04:05:00 AM CST'
date: invalid date `June 10, 2013 04:05:00 AM CST'
date: invalid date `July 10, 2013 04:05:00 AM CST'
date: invalid date `August 10, 2013 04:05:00 AM CST'
date: invalid date `September 10, 2013 04:05:00 AM CST'
date: invalid date `October 10, 2013 04:05:00 AM CST'
11/10
12/10

can someone please help me where i'm i going wrong here..
Note that in the United States in areas in the Central Time Zone, daylight savings time was in effect on all of the dates that failed.

See what happens if you change CST to CDT for those dates.

Alternatively, for the time being specified, the difference between CST and CDT doesn't matter, so you could try:
Code:
for i in January February March April May June July August September October November December
do      TZ=CST6 date -d "$i 10, 2013 04:05:00 AM CST" +%m/%d
done

 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

convert date format to mysql date format in log file

I have a comma delimited log file which has the date as MM/DD/YY in the 2nd column, and HH:MM:SS in the 3rd column. I need to change the date format to YYYY-MM-DD and merge it with the the time HH:MM:SS. How will I got about this? Sample input 02/27/09,23:52:31 02/27/09,23:52:52... (3 Replies)
Discussion started by: hazno
3 Replies

2. Shell Programming and Scripting

Which is the STRING format in the date command?

Hi According with the 'date' command documentation My question is, which are the possible values for STRING? I have been looking in the man pages but I didn't find anything? After some googling I have found it can have special values as 'now', 'yesterday' or 'tomorrow'. If it represents... (1 Reply)
Discussion started by: islegmar
1 Replies

3. HP-UX

Date format of ll command

Hi, Unix: HP-UNIX. I have a requirement(part of my requirement) to get latest file modification date of all files(In a particular directory). Using ll comand i m able to find out the modification date but not in the required format My command and out put: echo trp_pb.sql `ll... (2 Replies)
Discussion started by: satyadash
2 Replies

4. Shell Programming and Scripting

How to change date format in 'last' command?

hi.. i am new to here. can anybody tell me how can we change the date format in the 'last' command. EX- on running last command i am getting -- rruat pts/12 172.18.40.101 Tue May 3 12:59 still logged in rruat pts/10 blr2-3f-239.asco Tue May 3 12:59 - 13:09 ... (2 Replies)
Discussion started by: thearpit
2 Replies

5. Shell Programming and Scripting

Command for changing date format in a file

Hi... I have an inputfile name as :- abc_test_20120213.dat (date in yyyymmdd format) I need the output file name as abc_test_13022012.dat (date in ddmmyyyy format) Please help me on this... Thanks in advance. (5 Replies)
Discussion started by: gani_85
5 Replies

6. Shell Programming and Scripting

Display date in mm/dd/yy format in sed command

Hi All, Following is my issue. $MAIL_DOC = test.txt test.txt contains the following text . This process was executed in the %INSTANCE% instance on %RUNDATE%. I am trying to execute the following script var=`echo $ORACLE_SID | tr ` NOW=$(date +"%D") sed -e... (3 Replies)
Discussion started by: megha2525
3 Replies

7. UNIX for Dummies Questions & Answers

Rename all Files in a UNIX Directory from one date format to another date format

Hi Unix Gurus, I would like to rename several files in a Unix Directory . The filenames can have more than 1 underscore ( _ ) and the last underscore is always followed by a date in the format mmddyyyy. The Extension of the files can be .txt or .pdf or .xls etc and is case insensitive ie... (1 Reply)
Discussion started by: pchegoor
1 Replies

8. Shell Programming and Scripting

Need command for date format

hi all, i had a requirement in my script iam passing the parameter like (its not the system date iam passing as argument like it can be any date) 2014-08-25 but in my output file it should be 08/25/2014 please guide me thanks in advance hemanthsaikumar (3 Replies)
Discussion started by: hemanthsaikumar
3 Replies

9. Shell Programming and Scripting

Date command comparision with a different format

I have a script called " passwd_status " which gives the passwd-s status of my servers. the script output is like below password status for A: abc ks 10/05/115 1 30 ps password status for B: abc ks 09/25/115 1 30 ps password status for C: abc ks 10/10/115 1 30 ps Now , i want to... (1 Reply)
Discussion started by: charanarjun
1 Replies

10. Shell Programming and Scripting

Command to check date format DDMMYYYY

Record: Record1|Record2|Record3|Record4|Record5|DATE1|DATE2 Need to Check DATE1 & DATE2 is in DDMMYYYY format in a file. records which not meet the date format DDMMYYYY extract to other file. (1 Reply)
Discussion started by: vivekn
1 Replies

LEARN ABOUT DEBIAN

cgi::untaint::date

CGI::Untaint::date(3pm) 				User Contributed Perl Documentation				   CGI::Untaint::date(3pm)

NAME

       CGI::Untaint::date - validate a date

SYNOPSIS

	 use CGI::Untaint;
	 my $handler = CGI::Untaint->new($q->Vars);

	 my $date = $handler->extract(-as_date => 'date');

DESCRIPTION

       is_valid

       This Input Handler verifies that it is dealing with a reasonable date. Reasonably means anything that Date::Manip thinks is sensible, so
       you could use any of (for example):
	 "December 12, 2001"
	 "12th December, 2001"
	 "2001-12-12"
	 "next Tuesday"
	 "third Wednesday in March"

       See Date::Manip for much more information on what date formats are acceptable.

       The resulting date will be a Date::Simple object.  Date::Simple for more information on this.

       date_format

       By default ambiguous dates of the format 08/09/2001 will be treated as UK style (i.e. 8th September rather than 9th August)

       If you want to change this, subclass it and override date_format()

WARNING

       Date::Manip does not play nicely with taint mode. In order to work around this we locally clobber Date::Manip's 'timezone' code. As we're
       only interested in dates rather than times, this shouldn't be much of an issue. If it is, then please let me know!

SEE ALSO

       Date::Simple. Date::Manip.

AUTHOR

       Tony Bowden

BUGS and QUERIES
       Please direct all correspondence regarding this module to:
	 bug-CGI-Untaint-date@rt.cpan.org

COPYRIGHT and LICENSE
       Copyright (C) 2001-2005 Tony Bowden. All rights reserved.

       This module is free software; you can redistribute it and/or modify it under the same terms as Perl itself.

perl v5.10.0							    2008-05-12						   CGI::Untaint::date(3pm)
All times are GMT -4. The time now is 12:05 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy