Date conversion

Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Date conversion
# 1  
Old 08-06-2009
Bug Date conversion


I have the string YYYYMMDDHHMMSS like 20090801204150 and I need to convert it using the unix command date in the format:
date "Saturday, 1 August 2009 20:40:59"

All in one single Unix line if this is possible. What's the correct syntax?

Steve Hagi
# 2  
Old 08-06-2009
date -d "20090801204150" "+%A, %d %B %Y %H:%M:%S"

This only works with GNU date (usually comes with Linux)
# 3  
Old 08-06-2009
Hi Jim,

thanks for quick reply. Anyway I receive:

date: settimeofday (timezone): Operation not permitted

I don't need to set date, I need only to convert and get a string formatted from YYYYMMDDHHMMSS input. We use OS X.

Steve Hagi
# 4  
Old 08-06-2009
Sounds like Apple excised that feature from their strange half-GNU UNIX base... Pity. GNU date's usefulness is severely limited by the single format in which it will accept dates anyway though, and this format is not it. On my system I'd be severely tempted to use mysql for date processing just because I have it.
# 5  
Old 08-06-2009
Should work for you.
# DATE=20090801204150
# date -jf "%Y%m%d%H%M%S" $DATE "+date \"%A,%_d %B %Y %H:%M:%S\""
date "Saturday, 1 August 2009 20:41:50"

# 6  
Old 08-06-2009
Hi Danmero thanks for the input. I need on one line, so I try to change as

date -jf "%Y%m%d%H%M%S" "20090801204150" "+date \"%A,%_d %B %Y %H:%M:%S\""

but I receive:
date: illegal time format

Maybe incorrect syntax?
# 7  
Old 08-06-2009
Smilie Works for me on bash/FreeBSD 7.2
For csh try:
# # date -jf '%Y%m%d%H%M%S' "20090801204150" '+date "%A,%_d %B %Y %H:%M:%S"'
date "Saturday, 1 August 2009 20:41:50"

and take a look at Mac OS X Manual Page For date(1), Sorry but I'm not a Mac user Smilie
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. UNIX for Beginners Questions & Answers

Date conversion

Hi , we have a string with yyyymmdd format . how to know which date it is ? example:20120712-->sunday 20150228-->saturday 20140431-->invalid please suggest commands which work on below os : SunOS 5.10 shell: bash shell Thanks, Srinath. (10 Replies)
Discussion started by: srinadhreddy27
10 Replies

2. Shell Programming and Scripting

Date conversion

Trying to convert dates using a Perl Script but it has to accept formats like 3 letter month, day and year like Nov 02 2010 or 1/4/11 or 21 Feb 2011 and have it convert to something like October 20, 2011. Any ideas? (2 Replies)
Discussion started by: reduxeffect81
2 Replies

3. Shell Programming and Scripting

Julian date to Calendar date conversion

Hi all, I require to convert julian date to normal calander date in unix for eg julian date=122 now i want corresponding calander date ---------------------------------------- gr8 if give very small command/script and please explain the steps as well(imp) Thanks ... (3 Replies)
Discussion started by: RahulJoshi
3 Replies

4. UNIX for Dummies Questions & Answers

Date conversion in ab i

(string(8)) ((date("YYYYMMDD")) ((date("YYYY/MM/DD")) in.date_field_name)) (1 Reply)
Discussion started by: dr46014
1 Replies

5. Shell Programming and Scripting

Conversion of date to Julian date

Hi Gurus, Need help in Conversion of date(2007-11-30) to Julian date(YYDDD)... '+%J' 2007-11-30 to 'YYDDD' Thanks (4 Replies)
Discussion started by: SeenuGuddu
4 Replies

6. Shell Programming and Scripting

Date conversion

Hi I want to convert MAY 05 2005 01:15:00PM date format to 2005/05/05 01:15:00PM . CAn somebody suggest me a code ,I am new to unix shell programming. Thanks Arif (21 Replies)
Discussion started by: mab_arif16
21 Replies

7. Shell Programming and Scripting

Date Conversion

Hi, Does anyone know (in KSH, CSH, SED or AWK), how to convert date text in a file from: EX: May232008 to: 05232008 Thanks, (3 Replies)
Discussion started by: jgrant746
3 Replies

8. Shell Programming and Scripting

date conversion

file1 E106,0,1/9/1993,0,E001,E003,A,45200,3766.667,21.730769 E108,0,2/3/1995,0,E001,E003,A,15000,1250,7.211538 E109,0,06-mar-07,0,E001,E001,A,78000,6500,37.5 E110,0,09-dec-2008,0,E001,E001,A,56000,4666.667,26.923077 E104,0,06/04/1994,0,E001,E003,A,95000,7916.667,45.673077... (14 Replies)
Discussion started by: charandevu
14 Replies

9. Shell Programming and Scripting

date conversion

Hi everybody: Could anybody tell me how I convert from a julian date, with shell comands, to gregorian. Thanks in advance. (2 Replies)
Discussion started by: tonet
2 Replies

10. UNIX for Advanced & Expert Users

Date Conversion

Hello, I want to convert MM DD YYYY date format to MM-DD-YYYY format. For exemple: I have to convert Nov 28 2005 to 28-11-2005. Thenks for youf help. DAFI (2 Replies)
Discussion started by: dafidak
2 Replies
Login or Register to Ask a Question