Date format
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Date format

  1. #1
    Join Date
    Dec 2000
    Posts
    95

    Question Date format

    HI,

    I having problem with the following date format.

    2002-04-09 18:25:05.0
    yyyy-mm-dd HH24:MI:SS.?

    Can somebody help me to find out the last digit's format?

    Thank you,
    Srinivas Medukonduru

  2. #2
    Join Date
    Nov 2002
    Posts
    2
    I'm reasonably sure the Oracle DATE datatype doesn't support milliseconds.

  3. #3
    Join Date
    Aug 2002
    Posts
    35
    try using data type TIMESTAMP
    its new feature in 9i
    "Be not afraid of growing slowly. Be afraid only of standing still."

Posting Permissions

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


Click Here to Expand Forum to Full Width