Convert string (YYYYMMDD) format to date in Sun OS Post: 303015094

Sponsored Content

Operating Systems Solaris Convert string (YYYYMMDD) format to date in Sun OS Post 303015094 by Chubler_XL on Tuesday 27th of March 2018 04:32:27 PM

03-27-2018

Moderator

You could do this with perl eg:

Code:

#!/bin/perl
use POSIX;
use Time::Local;

my ($yyyy, $mm, $dd) = (
   $ARGV[0] =~ /([0-9]{4}) ([0-9]{2}) ([0-9]{2})/x
);

eval {
   print strftime("%a\n", localtime(timelocal(0,0,0,$dd,$mm - 1,$yyyy)))
};
print "ERROR: Format is YYYYMMDD\n" if $@;

Or, for a bit if fun, you could use cal and nawk like this:

Code:

Y=${1%????}
M=${1#????}
D=${M#??}
M=${M%??}
cal $M $Y | nawk '/^[A-Z]/ { split($0, dayname, " ") } dayname[1] && match($0, wd) { print dayname[int((RSTART+2)/3)] ; exit }' wd=$D

Assumption here is that each day takes three vertical text columns like this so when we find a day in the cal output we can calculate the heading it is under:

Code:

     March 2018     
Su Mo Tu We Th Fr Sa
             1  2  3 
 4  5  6  7  8  9 10 
11 12 13 14 15 16 17 
18 19 20 21 22 23 24 
25 26 27 28 29 30 31

Chubler_XL

View Public Profile for Chubler_XL

Find all posts by Chubler_XL

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

get yesterday date in yyyymmdd format

I would like to know how I could get a yesterday date in yyyymmdd e.g. today is 20011109, and I would like to get 20011108. Thank you!:confused:

2. UNIX for Dummies Questions & Answers

how to convert the string YYYYMMDD into YYYY.MM.DD

how to convert the string YYYYMMDD into YYYY.MM.DD Please advice

3. UNIX for Dummies Questions & Answers

Format date from MM/DD/YYYY to YYYYMMDD

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

4. Shell Programming and Scripting

convert date format YYYYMMDD to MM/DD/YYYY

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.

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

6. Shell Programming and Scripting

PERL String to Date (Custom format yyyymmdd to dd-mon-yyyy)

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

7. Solaris

Date after 5 dates in YYYYMMDD format

Hi Experts, How to get date 5 days after current date in YYYYMMDD format? How do we compare date in YYYYMMDD format? Thanks

8. Shell Programming and Scripting

Date after 5 days from current date in YYYYMMDD format

Hello Experts, How do i get date after 5 days from current date in YYYYMMDD format? How do you compare date in YYYYMMDD format? Thanks

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

10. Shell Programming and Scripting