Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2008
    Posts
    1

    Unanswered: Not able to convert date in req format in procedure

    Hi,

    I am facing a problem in comparing to dates which are in diffrent format.

    Actually I am taking a date from a varchar column which is in DD-Mon-YYYY format and I need to compare that with MM/DD/YYYY format. I am not able to convert the dates in same format in a procedure.

    Any Light on this that how can I convert them and compare them.

    Thanks in advance.

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    True date datatypes have NO format.

    >date from a varchar column
    STRINGS are stored in VARCHAR column; NOT dates.

    Learn how to use TO_DATE to convert strings to date datatypes.
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

Posting Permissions

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