04-06-2012
Change the date format
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 idea?
Thanks a lot
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. Solaris
dear members,
ls -l
drwxr-xr-x 40 root sys 1024 Jul 11 22:19 usr
drwxr-xr-x 43 root sys 1024 Feb 1 2009 var
i am using solaris 10
is that possibe to do
drwxr-xr-x 40 root sys 1024 25-08-2009 22:19 usr
drwxr-xr-x 43 root sys ... (4 Replies)
Discussion started by: hosney00ux
4 Replies
5. 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
6. 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
7. 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
8. 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
9. 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
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 DEBIAN
px_timestamp2string
PX_TIMESTAMP2STRING(3) Library Functions Manual PX_TIMESTAMP2STRING(3)
NAME
PX_timestamp2string -- Convert paradox timestamp into formated string
SYNOPSIS
#include <paradox.h>
char * PX_timestamp2string(pxdoc_t *pxdoc, double timestamp, const char *format)
DESCRIPTION
Creates a string representation of a paradox timestamp as specified in the parameter format. The timestamp must be either retrieved with
PX_get_data_double(3) after calling PX_get_record(3) or by simply using the double value in the pxval_t struct as returned by
PX_retrieve_record(3). A timestamp contains both time and date information. The format string contains chars which stand for certain values
of the date/time. The following table lists all available characters with a meaning. All other characters are being copied unmodified to
the output string. If a special character shall not be interpreted it must be preceded with a backslash.
Characters and their meaning in date/time format string
Character Meaning
Y year, numeric, 4 digits
y year, numeric, 2 digits
m month, numeric
n month, numeric, no leading zeroes
d day of the month, numeric
j T{
day of the month, numeric, no leading zeros
T}
H hour, numeric, 24 hour format
h hour, numeric, 12 hour format
G T{
hour, numeric, 24 hour format, no leading zeroes
T}
g T{
hour, numeric, 12 hour format, no leading zeroes
T}
i minutes, numeric
s seconds, numeric
A AM/PM
a am/pm
L boolean for leap year
RETURN VALUE
Returns pointer to string on success and NULL on failure.
SEE ALSO
PX_time2string(3), PX_date2string(3)
AUTHOR
This manual page was written by Uwe Steinmann uwe@steinmann.cx.
PX_TIMESTAMP2STRING(3)