How to enter a date and time without to_date()
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: How to enter a date and time without to_date()

  1. #1
    Join Date
    Aug 2001
    Location
    UK
    Posts
    12

    Question How to enter a date and time without to_date()

    I am using a web package that creates insert statements for me. If it reads a row that contains date and time info it creates an insert statement using a preset format model. I can tune this format model to match the format oracle is expecting but I can't work out what format to include the time element. Any ideas?
    Martin L White
    OCP DBA 8i

    Argue your limitations and they are yours....

  2. #2
    Join Date
    Dec 2002
    Location
    Bangalore,Karnataka, India
    Posts
    9

    Question

    Dear Martin,

  3. #3
    Join Date
    Dec 2002
    Location
    Bangalore,Karnataka, India
    Posts
    9
    Dear Martin,

    Please discard my earlier message.

    In the subject matter, from the web, anyway you would be calling a SQL session. At that time, you can set the default date format you want by NLS_DATE_FORMAT which can take care of time component also. Hereafter you may set any time format suitable for you.

    Hope I'm clear.

    Regards,

    Eldo.

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