[SOLVED] date format conversion

iddarth.85 · 04-29-2011, 02:09 AM

hi people,

can you please help me in conversion of the date as per the below format.

--------------------
convert "2011-03-26 15:18:39.890480" to "Feb 2, 2009 2:00:00 PM 000000"

--------------------
Thanks in dvance....

druuna · 04-29-2011, 02:21 AM

Hi,

Code:

date --date="2011-03-26 15:18:39.890480" '+%b %d, %Y %X %p %N'

See the date man page for all details.

Hope this helps.

iddarth.85 · 04-29-2011, 03:26 AM

thanks druuna.... my doubt is solved....

But there is a small change to be done in your code....

Code:

date --date="2011-03-26 15:18:39.890480" '+%b %d, %Y %X %p %N'

the output for the above command is
Mar 26, 2011 03:18:39 PM PM 890480000

so removing "%p" gives the exact output

Code:

date --date="2011-03-26 15:18:39.890480" '+%b %d, %Y %X %p %N'

the output for the above command is
Mar 26, 2011 03:18:39 PM 890480000

druuna · 04-29-2011, 03:36 AM

Hi,

The locale setting comes into play when using %X.

You can either remove the %p (as you already discovered) or change the %X to %T and leave the %p in place. The second one is more general and does not depend on the set locale (the initial solution I posted works on my box, which probably has a different locale setting).

Hope this clears things up a bit.