12-15-2011
Converting Date from YYYYMMDD to DD-MON-YYYY
Hi , I need to convert date from YYYYMMDD to DD-MON-YYYY
e.g
20111214 to 14-Dec-2011
Please help.
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
how to convert the string YYYYMMDD into YYYY.MM.DD
Please advice (1 Reply)
Discussion started by: spatra
1 Replies
2. Shell Programming and Scripting
I want to change a date from format dd-mmm-yyyy to mm/dd/yyyy. Is there a way to do this with sed or do you have to write a case statement to convert JAN to 01? Thanks (9 Replies)
Discussion started by: stringzz
9 Replies
3. Shell Programming and Scripting
How to convert the date field from dd/mm/yyyy to yyyy/mm/dd in unix
my script will generate text file which have two fields
one is date and another is name of the server for example this is sample date which I have to sort based on older to newer date the problem is when I found out sort will... (4 Replies)
Discussion started by: pareshan
4 Replies
4. UNIX for Dummies Questions & Answers
I have a file with some date columns in MM/DD/YYYY format:
SMPBR|DUP-DO NOT USE|NEW YORK||16105|BA5270715|6/6/2007 |MWERNER|109||||JOHN||SMITH|MD|72211118||||||74559|21 WILMINGTON RD||D|11/6/2003|SL# MD CONTACT-LIZ RICHARDS|||0|Y|N||1411458|
And I want to convert the date format to:
... (5 Replies)
Discussion started by: ChicagoBlues
5 Replies
5. Shell Programming and Scripting
In my shell script i have a variable which stores date in the format of YYYYMMDD. Is there any way to format this value to MM/DD/YYYY.
Thanks. (8 Replies)
Discussion started by: nasirgondal
8 Replies
6. Shell Programming and Scripting
Hi All,
I am learning PERL for one of the projects, and in one of these scripts, I read a flat text file and print in the terminal.
The problem is, the text file has a date field. The format is yyyymmdd. I need to display this as dd-mon-yyyy.
Any ideas to do this? Thanks a lot for the... (9 Replies)
Discussion started by: guruparan18
9 Replies
7. Shell Programming and Scripting
(Attention: Green PHP newbie !)
I have an online inquiry form, delivering a date in the form yyyy/mm/dd to my feedback form. If the content passes several checks, the form sends an e-mail to me. All works fine. I just would like to receive the date in the form dd/mm/yyyy. I tried with some code,... (6 Replies)
Discussion started by: keyboarder
6 Replies
8. Shell Programming and Scripting
Hello,
I am writing a script that parses different logs and produces one. In the source files, the date is in DD MM YYYY HH24:MI:SS format. In the output, it should be in DD MON YYY HH24:MI:SS (ie 25 Jan 2010 16:10:10)
To extract the dates, I am using shell substrings, i.e.:
read line
... (4 Replies)
Discussion started by: Adamm
4 Replies
9. Shell Programming and Scripting
Hi I have a problem with Date format in my code.
1st I am trying to convert today's date to yesterday's using
YESTERDAY3=`perl -e '@y=localtime(time()-86400); printf "%04d/%02d/%02d",$y+1900,$y+1,$y;$y;'`
And once it is done I am trying to using the yesterday date in a grep command to... (3 Replies)
Discussion started by: nithinankam
3 Replies
10. Programming
Hi All,
I have line
,A,FDRM0002,12/21/2017,,0.961751583,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
it contains date in mm/dd/yyyy format i want to change this to yyyymmdd format using perl.
Use code tags, thanks. (8 Replies)
Discussion started by: vishal0746
8 Replies
LEARN ABOUT DEBIAN
datetime::format::sqlite
DateTime::Format::SQLite(3pm) User Contributed Perl Documentation DateTime::Format::SQLite(3pm)
NAME
DateTime::Format::SQLite - Parse and format SQLite dates and times
SYNOPSIS
use DateTime::Format::SQLite;
my $dt = DateTime::Format::SQLite->parse_datetime( '2003-01-16 23:12:01' );
# 2003-01-16 23:12:01
DateTime::Format::SQLite->format_datetime($dt);
DESCRIPTION
This module understands the formats used by SQLite for its "date", "datetime" and "time" functions. It can be used to parse these formats
in order to create DateTime objects, and it can take a DateTime object and produce a timestring accepted by SQLite.
NOTE: SQLite does not have real date/time types but stores everything as strings. This module deals with the date/time strings as
understood/returned by SQLite's "date", "time", "datetime", "julianday" and "strftime" SQL functions. You will usually want to store your
dates in one of these formats.
METHODS
This class offers the methods listed below. All of the parsing methods set the returned DateTime object's time zone to the UTC zone
because SQLite does always uses UTC for date calculations. This means your dates may seem to be one day off if you convert them to local
time.
o parse_datetime($string)
Given a $string representing a date, this method will return a new "DateTime" object.
The $string may be in any of the formats understood by SQLite's "date", "time", "datetime", "julianday" and "strftime" SQL functions or
it may be in the format returned by these functions (except "strftime", of course).
The time zone for this object will always be in UTC because SQLite assumes UTC for all date calculations.
If $string contains no date, the parser assumes 2000-01-01 (just like SQLite).
If given an improperly formatted string, this method may die.
o parse_date($string)
o parse_time($string)
o parse_julianday($string)
These are aliases for "parse_datetime", for symmetry with "format_*" functions.
o format_date($datetime)
Given a "DateTime" object, this methods returnes a string in the format YYYY-MM-DD, i.e. in the same format SQLite's "date" function
uses.
o format_time($datetime)
Given a "DateTime" object, this methods returnes a string in the format HH:MM:SS, i.e. in the same format SQLite's "time" function
uses.
o format_datetime($datetime)
Given a "DateTime" object, this methods returnes a string in the format YYYY-MM-DD HH:MM:SS, i.e. in the same format SQLite's
"datetime" function uses.
o format_julianday($datetime)
Given a "DateTime" object, this methods returnes a string in the format DDDDDDDDDD, i.e. in the same format SQLite's "julianday"
function uses.
AUTHOR
Claus Faerber <CFAERBER@cpan.org>
based on "DateTime::Format::MySQL" by David Rolsky.
Copyright X 2008 Claus Faerber.
Copyright X 2003 David Rolsky.
This program is free software; you can redistribute it and/or modify it under the same terms as Perl itself.
The full text of the license can be found in the LICENSE file included with this module.
SEE ALSO
http://datetime.perl.org/
http://www.sqlite.org/lang_datefunc.html
perl v5.10.1 2009-12-10 DateTime::Format::SQLite(3pm)