Results 1 to 2 of 2

Thread: to_date issues

  1. #1
    Join Date
    Jun 2003
    Posts
    1

    Unanswered: to_date issues

    Using orcale we run into an issue intermittently where we get strange data in date fields in our oracle data. We are using an ASP front end for the application and, on occasion, our date fields will be populated with information such as: mm/dd/yyyy HH:MM:02 or :04 or something of the sort when we are trying to insert a new record using the to_date function.

    We don't need or want the time information from within our application, just the date in short date format. Some of our database transactions do take quite a while to perform and affect multiple rows of data and I've wondered if maybe the lag between the execution of the SQL command and the commit of the transaction could be causing this issue.

    Any help would be appreciated.

    shane

  2. #2
    Join Date
    Apr 2003
    Location
    Greenville, SC (USA)
    Posts
    1,155
    Try

    trunc(sysdate)


    sql> select trunc(sysdate) from dual;

    This strips off the time portion of the date

    Gregg

Posting Permissions

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