Results 1 to 3 of 3
  1. #1
    Join Date
    Feb 2003
    Posts
    107

    Unanswered: formatting oracle date for display.

    I have an oracle date being sent to my asp page. by default it appears as 112656900000.
    In the database, it appears as 13-SEPT-2005 120000AM.
    How do convert this to display something like Sept 13, 2005 in ASP?
    Please and thanks.

  2. #2
    Join Date
    Jun 2003
    Location
    USA
    Posts
    1,032
    To show a date like July 25, 2005:

    <%= MonthName(Month(MyDate)) %>&nbsp;<%= Day(MyDate) %>,&nbsp;<%=Year(MyDate) %>
    J. Paul Schmidt, Freelance Web and Database Developer
    www.Bullschmidt.com
    Access Database Sample, Web Database Sample, ASP Design Tips

  3. #3
    Join Date
    Feb 2003
    Posts
    107

    Oracle Date

    That doesn't seem to work.
    Getting the error:

    Error Type:
    Microsoft VBScript runtime (0x800A000D)
    Type mismatch: '[string: "1058400000000"]'
    /issueview/test.asp, line 6

    The code looks like:
    <%= MonthName(Month("1058400000000")) %>&nbsp;<%= Day("1058400000000") %>,&nbsp;<%=Year("1058400000000") %>

Posting Permissions

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