09-10-2013
[Solved] Change Date from one format to other
Hi
I wish to change date from one format to another in unix.
eg: INPUT DATE: 2013159 (YEAR & NUMBER OF DAY)
OUTPUT DATE required: 20130608 (YYYYMMDD)
how to do it ?
Thanks in advance.
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
Hi,
I want to know how to change this string to date format
20061102122042 to 02-11-2006 12:20:42
or 02-Nov-2006 12:20:42
Please let me know at the earliest.Thanks in advance.
Regards,
Preetham R. (3 Replies)
Discussion started by: preethgideon
3 Replies
2. UNIX for Advanced & Expert Users
I know the command date +"%Y%m%d" can change today's date to digit format as below .
$date +"%Y%m%d"
20071217
it works fine .
now I want to do it back . If I have a file like below, (in the file , there are three lines, and each line have ; sign , after the ; sign is the date ) , I... (4 Replies)
Discussion started by: ust
4 Replies
3. Shell Programming and Scripting
Hi All,
this is my second post, last post reply was very helpful.
I have a data that has date in DD/MM/YYYY (07/11/2008) format i want to replace the backslash by a dot(.) so that my awk script can read it inside the C shell script that i have written.
i want to change 07/11/2008 to... (3 Replies)
Discussion started by: asirohi
3 Replies
4. Shell Programming and Scripting
Hi I have a date format in a variable as Mon Jan 11 03:35:59 2010. how do i change it to YYYYMMDD format (3 Replies)
Discussion started by: keerthan
3 Replies
5. Shell Programming and Scripting
Hi guys,
I have a text file with lots of lines like this:
MCOGT23R27815 27/07/07 27/05/09
SO733AM0235 30/11/07 30/11/10
NL123403N 04/03/08 04/03/11
0747AM7474 04/04/08 04/04/11
I want to change each line so the date format looks like this:
MCOGT23R27815 07/07/27 09/05/27 ... (7 Replies)
Discussion started by: Tornado
7 Replies
6. Shell Programming and Scripting
Hi,
Please can I have some command to get yesterday in YYMMDD format?
This will be used in ksh
Thanks, (2 Replies)
Discussion started by: smalya
2 Replies
7. Shell Programming and Scripting
Dear Friends,
Need your help once again,
I have a variable ( e.g. ${i}) whoch has date in MM/DD/YYYY (E.g. 12/31/2011) format.
I want to change it to DD/MM/YYYY (e.g. 31/12/2011) format.
Request you to guide me as we are unable to do the same.
Thanks in advance
Anu. (1 Reply)
Discussion started by: anushree.a
1 Replies
8. Shell Programming and Scripting
Hi,
I have the variable "$date_update" in that form:
2011-12-31T13:00:09Z and I would like to change it to
31/12/2011 13:00:09 (Date and Time separated by a blank).
Does anyone has a simple solution for that? (using Korn Shell)
Cheers
Jurgen (4 Replies)
Discussion started by: jurgen
4 Replies
9. Shell Programming and Scripting
Hi all,
I have a file that every line starts with the date and time. The format is like YYYYMMDDHHMM and I woulk like to change it to MM/DD/YY<space>HH:MM.
I tried to figure out a way to do it with sed, but I don't know how I could reorganize the digits of the first format. Does anyone have any... (1 Reply)
Discussion started by: geovas
1 Replies
10. Shell Programming and Scripting
Hi,
I was looking for a script to change the date from one format to other. A search in the forum gave me the below script as a result.
#! /bin/ksh
format=YYYYMMDD
YEAR=${format%????}
DAY=${format#??????}
MON=${format#$YEAR}
MON=${MON%$DAY}
echo $MON/$DAY/$YEAR
I got it... (2 Replies)
Discussion started by: prithvirao17
2 Replies
LEARN ABOUT MOJAVE
dbix::class::storage::dbi::informix5.18
DBIx::Class::Storage::DBI::Informix(3) User Contributed Perl Documentation DBIx::Class::Storage::DBI::Informix(3)
NAME
DBIx::Class::Storage::DBI::Informix - Base Storage Class for Informix Support
DESCRIPTION
This class implements storage-specific support for the Informix RDBMS
METHODS
connect_call_datetime_setup
Used as:
on_connect_call => 'datetime_setup'
In connect_info to set the "DATE" and "DATETIME" formats.
Sets the following environment variables:
GL_DATE="%m/%d/%Y"
GL_DATETIME="%Y-%m-%d %H:%M:%S%F5"
The "DBDATE" and "DBCENTURY" environment variables are cleared.
NOTE: setting the "GL_DATE" environment variable seems to have no effect after the process has started, so the default format is used. The
"GL_DATETIME" setting does take effect however.
The "DATETIME" data type supports up to 5 digits after the decimal point for second precision, depending on how you have declared your
column. The full possible precision is used.
The column declaration for a "DATETIME" with maximum precision is:
column_name DATETIME YEAR TO FRACTION(5)
The "DATE" data type stores the date portion only, and it MUST be declared with:
data_type => 'date'
in your Result class.
You will need the DateTime::Format::Strptime module for inflation to work.
AUTHOR
See "AUTHOR" in DBIx::Class and "CONTRIBUTORS" in DBIx::Class.
LICENSE
You may distribute this code under the same terms as Perl itself.
perl v5.18.2 2013-12-16 DBIx::Class::Storage::DBI::Informix(3)