Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2003
    Posts
    55

    Unanswered: datetime field conversion...hellpppp!

    hi all

    Is there anyway i ca convert a date of the form: 30/12/2002 to a datetime field in perl?
    the convert function fails as gives me arithmetic overflow because for conversion to datetime the format has to be of the form : 30-Jan-02 that is the month 'name' should appear
    Please help if anyone knows how I can convert the above form to datetime format either in sql or from perl code..

    thnx fr ur time...n puhlezzzz any help wud be great

    -cheers!
    shuchi
    You try and try again..but then give up, there's no sense in being a complete fool about it!!!

  2. #2
    Join Date
    Jan 2003
    Posts
    55
    oops prob solved already..!
    guess was just a little hasty in posting the message....just used the convert function codes for datetime to convert..worked beautifully!

    thnx if any one tried to help

    ta

    -s
    You try and try again..but then give up, there's no sense in being a complete fool about it!!!

Posting Permissions

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