Shell Programming and Scripting

Hi All,

If i have a specific date say "20130619 01:02:02.123456" [YYYYMMDD format], what is the unix command to display in
CCYY-MM-DD.HH.MM.SS.mmmmmm format?


Thanks in Advance,

Check man date

What have you tried so far?


Read the manual pages for the date command and check all the options.




Robin

This does the job:

Code:

date -d '20130619 01:02:02.123456' +%C%y-%m-%d.%H.%M.%S.%N | cut -b1-26

Dear gacanepa,

This doesn't work for all flavours, and we're not told what is in use, hence why HemaV needs to read the manual pages for their system. I ran it and got just the output of your text, rather than the actual date. On my system, -d needs a different format so your string "20130619 01:02:02.123456" then occupies the first 26 bytes, so the actual date wanted is removed by your cut.



Robin

Dear Robin,
Good point - about the flavours.
However, if you read the original question, HemaV doesn't say he/she needs to convert the actual date, but a specific date (that is why I used the -d switch). The cut is there to trim the last 3 nano second places because HemaV wanted it to display up to microsecond precision.
BTW, I am running

Code:

Red Hat Enterprise Linux Server release 5.7 (Tikanga)

here.
As to the reading man date advice, I agree that's where one needs to start. But for a newbie (ok, we're not told that is the case, but we can assume that) a working example can make things a whole lot easier - and serve as a starting point to understand the actual man page.

---------- Post updated at 11:20 AM ---------- Previous update was at 11:17 AM ----------

HemaV,
If you need to format the current date to the format you specified in your original question (instead of a specific date), try this:

Code:

date +%C%y-%m-%d.%H.%M.%S.%N | cut -b1-26

Using that example, and reading the

Code:

man page

for

Code:

date

, you will be able to better adapt it to your needs and flavour of Unix, as rbatte1 suggested earlier.

I was thinking CC format is something in Julian date format and by reading the below posts i came to know that its the 1st 2 digits of year.

Thanks,