DATE and TIME format help in HP-UX


 
Thread Tools Search this Thread
Operating Systems HP-UX DATE and TIME format help in HP-UX
# 1  
Old 10-20-2012
MySQL DATE and TIME format help in HP-UX

Hello,

I have date format as shown in red color below
Fri, Sep 12, 2012 08:38:05 PM

Can anyone help me with command to change this format to yyyy-mm-dd and HH:MM:SS

Note: Time should be in 24 hours format

I really appreciate your help!!

Thanks,
Elavarasan
# 2  
Old 10-20-2012
I assume you mean: use date command with another format --

Code:
date "+%Y-%m-%d %H:%M:%S"

The date format string starts with the + character, it does not show up in the output.
If you forget it you get an error message
This User Gave Thanks to jim mcnamara For This Post:
# 3  
Old 10-20-2012
Your command will give current date and time.

Thanks for your helping!!

Your command will give current date and time, but i will have old date and time that need to be convert to another format as shown in my first thread.... hmmmm
# 4  
Old 10-20-2012
Quote:
Originally Posted by Elavarasan
but i will have old date and time that need to be convert to another format as shown in my first thread....
Check if -d option is present or not..?

Code:
$date -d "Fri, Sep 12, 2012 08:38:05 PM" "+%Y-%m-%d %H:%M:%S"
2012-09-12 20:38:05

Or

Code:
date --date="Fri, Sep 12, 2012 08:38:05 PM" "+%Y-%m-%d %H:%M:%S"


Last edited by pamu; 10-20-2012 at 06:55 AM..
# 5  
Old 10-20-2012
Since there is no -d option present in HP-UX

Code:
export INP_DT="Fri, Sep 12, 2012 08:38:05 PM"
export FMT_DT=`echo ${INP_DT} | sed 's/\,/\//g;s/\:/\//g;s/ /\//g;s/\/\//\//g'`

perl '-MPOSIX qw(strftime)' -le'
    @dt = split /\//, $ENV{'FMT_DT'};
    print strftime( "%Y-%b-%d %I:%M:%S", $dt[6], $dt[5], $dt[4], $dt[2], $dt[1], $dt[3] - 1900 )';


Last edited by vbe; 10-23-2012 at 05:37 AM.. Reason: missing last ' ...
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Valid separator in time and date format

Hello. I can use any particular (stupid or not) format when using bash date command. Example : ~> date --date "now" '+%Y-%m-%d %H!%M!%S' 2019-06-03 12!55!33or ~> date --date "now" '+%Y£%m£%d %H¤%M¤%S' 2019£06£03 12¤57¤36 or ~> date --date "now" '+%Y-%m-%d %H-%M-%S' 2019-06-03 12-58-51 ... (4 Replies)
Discussion started by: jcdole
4 Replies

2. UNIX for Dummies Questions & Answers

How to chnage format and subtract time and date and get average.?

Hello All , Please support for below request how to change format and subtract time and date and get average. xxx 13-OCT-15 11.32.18.241000 AM 13-OCT-15 11.35.49.089080 AM xxx 13-OCT-15 11.32.24.000000 AM 13-OCT-15 11.45.17.810904 AM xxx 13-OCT-15 11.32.25.232000 AM ... (1 Reply)
Discussion started by: mirwasim
1 Replies

3. Shell Programming and Scripting

Change the date and time format in UNIX script.

Hi, I am extracting a date string from the source file like this : 06/05/2014 16:04:00 I want to change it to 05-JUN-14 04.05.00.000000000 PM I basically store the date in a variable. I got solutions to change date in dd-mmm-yyyy format using tr but I guess it works only with the "date"... (8 Replies)
Discussion started by: Varshha
8 Replies

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

5. UNIX for Dummies Questions & Answers

Shell Scripts - shows today’s date and time in a better format than ‘date’ (Uses positional paramete

Hello, I am trying to show today's date and time in a better format than ‘date' (Using positional parameters). I found a command mktime and am wondering if this is the best command to use or will this also show me the time elapse since 1/30/70? Any help would be greatly appreciated, Thanks... (3 Replies)
Discussion started by: citizencro
3 Replies

6. Shell Programming and Scripting

awk & date time format

This gives: grep "qprt -o -dp -N 1 -P" printfile.log.1216 |awk '{print $7, $9}' |grep lpc1z The output like below: lpc1z /cerner/d_prod/print/ccltemp4235396d030a.dat.tmp.1216075330] lpc1z /cerner/d_prod/print/ccltemp4235396d036a.dat.tmp.1216075634] lpc1z... (2 Replies)
Discussion started by: Daniel Gate
2 Replies

7. Shell Programming and Scripting

date and time in mm/dd/yyyy hh:mm format

Frens, I have a logfile which has got manier things in it and somewer in that file i have a date in mm/dd/yyyy hh:mm format.... I just need to get the date and time nothing else.... i have searched in this forum for it but got only date in mm-dd-yyyy format.. but i need to search for... (10 Replies)
Discussion started by: smarty86
10 Replies

8. Shell Programming and Scripting

Date and Time format

I want to append current date and time to a file name like filename_090920091210. If I use filename_`date +%d%m%Y%T`, the ouput is filename_0909200912:10:33. How to format this as filename_090920091210. Please let me know. Thanks in advance. (3 Replies)
Discussion started by: srimenon09
3 Replies

9. Shell Programming and Scripting

Convert Epoch time format to normal date time format in the same file

I have a file named "suspected" with series of line like these : {'protocol': 17, 'service': 'BitTorrent KRPC', 'server': '219.78.120.166', 'client_port': 52044, 'client': '10.64.68.44', 'server_port': 8291, 'time': 1226506312L, 'serverhostname': ''} {'protocol': 17, 'service': 'BitTorrent... (3 Replies)
Discussion started by: rk4k
3 Replies

10. Shell Programming and Scripting

format date/time presentation

1) i am trying to print the timeframe of a log file using the start/end date/time being extracted from the file itself. my problem is how to convert the following numeric date format to the one that i prefer: Start time: 0204161129 End time : 0204171431 into: Start time: Apr 16 2002... (6 Replies)
Discussion started by: apalex
6 Replies
Login or Register to Ask a Question