Login or Register to Ask a Question and Join Our Community


AIX

Convert string to date in script

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Operating Systems AIX Convert string to date in script
# 1  
Old 07-10-2009
Convert string to date in script
Hi,

How can I convert a string "Jul 10 09" to date in aix? the output can be like 20090710.

Thanks.
# 2  
Old 07-10-2009
A slight variation to something like...

https://www.unix.com/unix-dummies-que...two-dates.html
# 3  
Old 07-10-2009
I tried example from above link.

#!/bin/ksh93
date1="01/10/2009"
date2="06/10/2009"
if (( $(printf "%(%s)T" "$date1") > $(printf "%(%s)T" "$date2") ))
then
echo "date1 is after date2"
else
echo "date1 is not after date2"
fi

and getting following error: ()T > ()T : 0403-057 Syntax error
# 4  
Old 07-10-2009
I completey beg your pardon! Biggest fault, misread post.

I immediately read 20090710 as an epoch number - which it-s not!

All you need to do is convert the string to a number assiciated with it, and add 2000 to the year.

For example:
Code:
DATE="Jul 10 09"
MONTH=$(echo $DATE | cut -d  " " -f 1)
DAY=$(echo $DATE | cut -d  " " -f 2)
YEAR=$(echo $DATE | cut -d  " " -f 3)
 
case "$MONTH" in
Jan: M=1;;
Feb: M=2;;
...
esac
YEAR=$((YEAR+2000))
 
NEW_DATE="$YEAR$M$DAY"

# 5  
Old 07-13-2009
Thanks a lot scottn. This worked.
Login or Register to Ask a Question

Previous Thread | Next Thread

9 More Discussions You Might Find Interesting

1. Solaris

Convert string (YYYYMMDD) format to date in Sun OS

Hi All I need help in converting a string of YYYYMMDD format to date in Sun OS and then find out if the day is a Wednesday or not. The "date -d" option is not working and your help is much appreciated. The date command usage from the operating system we use here is as follows: Thanks, SK (11 Replies)
Discussion started by: SK123
11 Replies

2. Shell Programming and Scripting

Convert string to date and add 20 days

Hi, I have a requirement where I am getting date in string format (20161130). I need to add 20 days(not no. 20) to the above string. The o/p should 20161220. In case of 20170228, it should show 20170320. Could you please help me with the command to achieve this. Note: I am using AIX 7.1... (5 Replies)
Discussion started by: satyaatcgi
5 Replies

3. Shell Programming and Scripting

Convert string to date and add 1 hours

i have some set of date data inside csv files and need to convert the timezone, 08302016113611861 08302016113623442 08302016113541570 08302016113557732 08302016113548439 08302016112853115 08302016113620684 08302016113432827 08302016113630321 date format is : %m%d%Y%H%M%Smilisec ... (2 Replies)
Discussion started by: before4
2 Replies

4. Shell Programming and Scripting

Convert string into date format

Hi, I am getting the below string as a input for date. 12/03/2013 11:02 AM I want to change this date as 03-DEC-2013 11:02 AM. Could you please help on this. Thanks Chelladurai (4 Replies)
Discussion started by: ckchelladurai
4 Replies

5. Emergency UNIX and Linux Support

Convert string to date and add 1

Hi All, I want to convert string in format YYYYMMDD(20120607) to date in unix and add 1 day to it and convert back to string in format YYYYMMDD. Please help. (4 Replies)
Discussion started by: cns1710
4 Replies

6. Shell Programming and Scripting

To convert a date(in string format) to unix timestamp

Hi All, I have a string like below. "Mar 31 2009" . I want to convert this to unix time . Also please let me know how to find the unix time for the above string minus one day. For Eg. if i have string "Mar 31 2009" i want to find the unix time stamp of "Mar 30 2009". Thanks in advance,... (11 Replies)
Discussion started by: girish.raos
11 Replies

7. Shell Programming and Scripting

Convert String to Date Unix

Hi people, I need to convert a string eg 09/13/2008 to a valid unix date. (4 Replies)
Discussion started by: sameerspice
4 Replies

8. Shell Programming and Scripting

Convert String to Date

Hi, I have a String input parameter like this: 20080430 (YYYYMMDD). Inside my korn shell script I need to add one day to this date. L_TRADE_DAY=$1 let L_TODAY=$L_TRADE_DAY+1 Offcourse this raises a problem at the end of a month. 20080430 + 1 gives 20080431 instead of 20080501. ... (2 Replies)
Discussion started by: ORatjeuh
2 Replies

9. Shell Programming and Scripting

Convert DATE string to a formatted text

Hi guys, i need your help. I need to convert a date like this one 20071003071023 , to a formated date like 20071003 07:10:23 . Could this be possible ? Regards, Osramos (6 Replies)
Discussion started by: osramos
6 Replies
Login or Register to Ask a Question