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

Login or Register to Ask a Question and Join Our Community

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

Old

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

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

LEARN ABOUT SUSE

cal

CAL(1)							    BSD General Commands Manual 						    CAL(1)

NAME

     cal -- displays a calendar

SYNOPSIS

     cal [-smjy13] [[[day] month] year]

DESCRIPTION

     Cal displays a simple calendar.  If arguments are not specified, the current month is displayed.  The options are as follows:

     -1      Display single month output.  (This is the default.)

     -3      Display prev/current/next month output.

     -s      Display Sunday as the first day of the week.

     -m      Display Monday as the first day of the week.

     -j      Display Julian dates (days one-based, numbered from January 1).

     -y      Display a calendar for the current year.

     -V      Display version information and exit.

     A single parameter specifies the year (1 - 9999) to be displayed; note the year must be fully specified: ``cal 89'' will not display a calen-
     dar for 1989.  Two parameters denote the month (1 - 12) and year.	Three parameters denote the day (1-31), month and year, and the day will
     be highlighted if the calendar is displayed on a terminal.  If no parameters are specified, the current month's calendar is displayed.

     A year starts on Jan 1. The first day of the week is determined by the locale.

     The Gregorian Reformation is assumed to have occurred in 1752 on the 3rd of September.  By this time, most countries had recognized the ref-
     ormation (although a few did not recognize it until the early 1900's.)  Ten days following that date were eliminated by the reformation, so
     the calendar for that month is a bit unusual.

HISTORY

     A cal command appeared in Version 6 AT&T UNIX.

OTHER VERSIONS

     Several much more elaborate versions of this program exist, with support for colors, holidays, birthdays, reminders and appointments, etc.
     For example, try the cal from http://home.sprynet.com/~cbagwell/projects.html or GNU gcal.

AVAILABILITY

     The cal command is part of the util-linux-ng package and is available from ftp://ftp.kernel.org/pub/linux/utils/util-linux-ng/.

BSD
								   June 6, 1993 							       BSD