Results 1 to 3 of 3

Thread: Date Conversion

  1. #1
    Join Date
    Oct 2005
    Posts
    92

    Unanswered: Date Conversion

    Hi All,

    i have a directory such as;

    find /home/pavi/ctl/INFOSCAN.KKK.*.*.ctl* -exec ls -ltr {} \; | awk -F" " {'print $6 " " $7'}

    the output is : Jul 25

    can anyone please suggest me how do I convert the above Date into YYYYMMDD FORMAT.

    Thanks
    pavi

  2. #2
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    which database is this for?
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  3. #3
    Join Date
    Jan 2004
    Location
    Croatia, Europe
    Posts
    4,094
    Provided Answers: 4
    So you'd like to convert "Jul 25" into "YYYY0725"? Where's YYYY in "Jul 25"?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •