Solaris Date format help please


 
Thread Tools Search this Thread
Operating Systems Solaris Solaris Date format help please
# 1  
Old 02-03-2017
Solaris Date format help please

I have list of dates in a file. Am reading each line and trying to format date, Can you please help me ?

Sample file content:

Code:
02/22/16 USA is great country
02/21/16 USA future
02/23/16 who is he

I want to read each line from above file and format date as below

Code:
2016-02-21

(i.e., using the date utility format +%Y-%m-%d)

Can you please help me? Appreciate your help
Moderator's Comments:
Mod Comment Repeated failure to use CODE tags as required by forum rules has resulted in this user being placed in read-only mode for a day.

More infractions may result in this user being banned from this site permanently.

Last edited by Don Cragun; 02-03-2017 at 10:02 PM.. Reason: Change COLOR tags to CODE tags, add CODE and ICODE tags.
# 2  
Old 02-03-2017
  1. What have you tried to do this on your own?
  2. Are you trying to do this with a shell script?
    1. If not, what programming language do you want to use?
    2. If so, what shell are you using?
    3. Do you have the GNU utilities installed on your Solaris system?
  3. Is the date always the 1st "word" on a line in your file?
  4. Does every line in your file contain a date to be modified?
  5. Are all of your dates in the 21st century?
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Date: invalid date trying to set Linux date in specific format

i try to set linux date & time in specific format but it keep giving me error Example : date "+%d-%m-%C%y %H:%M:%S" -d "19-01-2017 00:05:01" or date +"%d-%m-%C%y %H:%M:%S" -d "19-01-2017 00:05:01" keep giving me this error : date: invalid date ‘19-01-2017 00:05:01' Please use CODE tags... (7 Replies)
Discussion started by: umen
7 Replies

2. Solaris

Solaris 5.8 Upgrade is causing Date format issue.

Hi I have a JAVA based application in development and production environment. These two environments are exactly identical in terms of OS, hardware and application components. Initially the OS was Solaris 5.6 and the application was working fine in both environments. But later when the OS... (12 Replies)
Discussion started by: Jayant Tripathi
12 Replies

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

4. Shell Programming and Scripting

finding date numeral from file and check the validity of date format

hi there I have file names in different format as below triss_20111117_fxcb.csv triss_fxcb_20111117.csv xpnl_hypo_reu_miplvdone_11172011.csv xpnl_hypo_reu_miplvdone_11-17-2011.csv xpnl_hypo_reu_miplvdone_20111117.csv xpnl_hypo_reu_miplvdone_20111117xfb.csv... (10 Replies)
Discussion started by: manas_ranjan
10 Replies

5. Solaris

Change date format in solaris 10

Hi We have upgraded our sun machine from solaris 9 to solaris 10. Before upgradation the date command output(Solaris 9) Wed Oct 13 09:45:21 IST 2010 But after upgradation the output for date is as below(solaris 10). Wednesday, October 13, 2010 9:46:14 AM IST Looks like I need to... (1 Reply)
Discussion started by: csreenivas
1 Replies

6. Shell Programming and Scripting

How to increment a user defined date value in the DATE format itself using shell script?

I need to increment a date value through shell script. Input value consist of start date and end date in DATE format of unix. For eg. I need increment a date value of 1/1/09 to 31/12/09 i.e for a whole yr. The output must look like 1/1/09 2/2/09 . . . 31/1/09 . . 1/2/09 . 28/2/09... (1 Reply)
Discussion started by: sunil087
1 Replies

7. Solaris

setting date format in solaris

Hi, i just want to know how to format date command in solaris. like in linux if i use `date +%s`, it gives me seconds since 1970, but in solaris (sol86) , it is giving %s as result. Is there any different way in solaris Thanks Sarbjit (1 Reply)
Discussion started by: sarbjit
1 Replies

8. UNIX for Dummies Questions & Answers

Changing from Excel date format to MySQL date format

I have a list of dates in the following format: mm/dd/yyyy and want to change these to the MySQL standard format: yyyy-mm-dd. The dates in the original file may or may not be zero padded, so April is sometimes "04" and other times simply "4". This is what I use to change the format: sed -i '' -e... (2 Replies)
Discussion started by: figaro
2 Replies

9. Shell Programming and Scripting

convert date format to mysql date format in log file

I have a comma delimited log file which has the date as MM/DD/YY in the 2nd column, and HH:MM:SS in the 3rd column. I need to change the date format to YYYY-MM-DD and merge it with the the time HH:MM:SS. How will I got about this? Sample input 02/27/09,23:52:31 02/27/09,23:52:52... (3 Replies)
Discussion started by: hazno
3 Replies

10. Shell Programming and Scripting

convert mmddyy date format to ccyyddd format??

hi, for reading a cobol indexed file i need to convert "mmddyy" date format to "ccyyddd" format. i checked the datecalc and other scripts but couldnt modify them to cater to my need:(... The datecalc gives an output which i believe is the total days till that date, but i want to convert it... (2 Replies)
Discussion started by: Bhups
2 Replies
Login or Register to Ask a Question