Visit Our UNIX and Linux User Community


Date format conversion function


 
Thread Tools Search this Thread
Top Forums UNIX for Dummies Questions & Answers Date format conversion function
# 1  
Old 08-30-2006
Date format conversion function

Hello,

does somebody knows about a function that would convert a date like:

YYMMDD into a date like YYYY-MM-DD ?

Thank you for your ideas

Smilie
# 2  
Old 08-30-2006
yes, one of the 'functions' is 'sed'
# 3  
Old 08-30-2006
date format conversion

I can have either :

070829 --> I want 2007-08-29
890829 --> 1989-08-29
# 4  
Old 08-30-2006
Quote:
Originally Posted by Cecile
I can have either :

070829 --> I want 2007-08-29
890829 --> 1989-08-29
ok, the 'function' 'sed' should be able to do it for you.
# 5  
Old 08-30-2006
The sed string to do that is worse than writing a shell function to do it IMO -
Code:
#!/bin/ksh
format ()
{
        yr=`expr substr $1 1 2`      
        month=`expr substr $1 5 2`
        day=`expr substr $1 7 2`
        if [[ $yr > "30" ]] ; then
             echo "19""$yr-$month-$day"
        else
             echo "20"$yr-$month-$day"
        fi
}

new_date=$(format "041012")
echo $new_date

Edit per vgersh99 observation.

Last edited by jim mcnamara; 08-30-2006 at 05:48 PM..
# 6  
Old 08-30-2006
Jim,
that was not the desired input format.

given a sample input file 'mySampleFile.txt':
Code:
070829
890829
050829

Code:
sed 's/\([^0].\)\(..\)\(..\)/19\1-\2-\3/g;s/\(0.\)\(..\)\(..\)/20\1-\2-\3/g' mySampleFile.txt

# 7  
Old 08-31-2006
Quote:
sed 's/\([^0].\)\(..\)\(..\)/19\1-\2-\3/g;s/\(0.\)\(..\)\(..\)/20\1-\2-\3/g' mySampleFile.txt
Script will fail on where year is 90, 80, 70 and so on:
Code:
echo "801229" | sed 's/\([^0].\)\(..\)\(..\)/19\1-\2-\3/g;s/\(0.\)\(..\)\(..\)/20\1-\2-\3/g'
198200--12--29

I think it should be:
Code:
sed 's/\([^0].\)\(..\)\(..\)/19\1-\2-\3/g;s/^\(0.\)\(..\)\(..\)/20\1-\2-\3/g' mySampleFile.txt

Regards,
Tayyab
 

Previous Thread | Next Thread
Test Your Knowledge in Computers #210
Difficulty: Easy
Routing protocols like OSPF calculate the shortest route to a destination through the network based on a computer algorithm.
True or False?

10 More Discussions You Might Find Interesting

1. UNIX for Beginners Questions & Answers

Date format conversion how to change this from using nawk to awk

Hi, I have a file where I need to change the date format on the nth field from DD-MM-YYYY to YYYY-MM-DD so I can accurately sort the record by dates From regex - Use sed or awk to fix date format - Stack Overflow, I found an example using nawk. Test run as below: $: cat xyz.txt A ... (2 Replies)
Discussion started by: newbie_01
2 Replies

2. Shell Programming and Scripting

Bash Scripting with date format conversion

I have a script below and wanted to change the output into three different file format (3 separate script) #!bin/bash #input file format postwrf_d01_20131206_0600_f08400.grb2 #postwrf_d01_YYYYMMDD_ZZZZ_f0HHHH.grb2 #zzzz= 0000,0600,1200,1800 (in UTC) #HHHH=00000,00600,01200,01800 ..ect (in... (1 Reply)
Discussion started by: cumulus_255
1 Replies

3. Shell Programming and Scripting

Date format conversion

Hi, i have to check the file whether it is created today. here is the ls -l o/p -rw-r----- 20000 50000 130 Dec 12 10:21 file.txt im able to check if file is created today or not if the timestamp is in 2014-12-12 format by comparing $(date +Y-%m-%d) but stuckup as it is of format Dec 12... (6 Replies)
Discussion started by: JSKOBS
6 Replies

4. Shell Programming and Scripting

Date conversion and Format

Hello , I have a record in below format Hostname | Query: 0 | Release: 0 | files: 2 | Files_examined: 2 | SET timestamp=1396778638; | select * from test I need output in below format Hostname | 0 | 0 | 2 | 2 | 04/06/2014|03:03:58 | select * from test I was able to get above output... (1 Reply)
Discussion started by: Tomlight
1 Replies

5. 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

6. Shell Programming and Scripting

Date conversion from 24 hr format to 12 hr format

hi i want to convert date procured from sone operation which will be in 24hr format to 12 hr format displaying AM and PM # date -d @1362545068 Tue Mar 5 23:44:28 EST 2013 # this Tue Mar 5 23:44:28 EST 2013 i want to convert it so that output is as below Tue... (2 Replies)
Discussion started by: vivek d r
2 Replies

7. Shell Programming and Scripting

Military type format date/time conversion

Hello All, I have a requirement to convert a 12 hour format to 24 hour time format and the sample input /out put is below Input Time format : Nov 2 2011 12:16AM Out Put Format : Nov 2 2011 0:16 Input : Nov 2 2011 4:16PM Out Put: Nov 2 2011 16:16 I have done this using a... (6 Replies)
Discussion started by: jambesh
6 Replies

8. Shell Programming and Scripting

Date format conversion

Hi All, Can someone please let me know how can i convert the date format in unix as follow: From: 24 Oct 2011 i.e $(date +'%d %b %Y') To: 111024 i.e $(date +%y%m%d) Thanks in advance (3 Replies)
Discussion started by: davidtd
3 Replies

9. 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

10. UNIX for Dummies Questions & Answers

date format conversion

hi, i have a file in which i get date format as 22/APR/2010... now i want the date format to be in 22-04-2010 if the month changes to may the file should also have 05 as month.... pls help (3 Replies)
Discussion started by: siva_nagarajan
3 Replies

Featured Tech Videos