DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Date conversion function

  1. 02-15-2002, 12:02 PM #1
    akwete
    akwete is offline Member
    Join Date
    Dec 2001
    Location
    Atlanta
    Posts
    175

    Cool

    Hey guys,

    I need help. I am trying to write a function that will convert
    date format in SQL Server xx/xx/xxxx to Oracle date format yy-yy-yyyy.
    If any one has written such script please help me. The Web Database is presently running on Oracle 9i. So the function can be in any language preferably VB, C++, PL/SQL and Java.
    Your help will be appreciated. Thank you
    Reply With Quote Reply With Quote
  2. 02-15-2002, 01:34 PM #2
    marist89's Avatar
    marist89
    marist89 is offline Super-Genius
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    to_date ?

    http://otn.oracle.com/docs/products/...tion.htm#84916
    Jeff Hunter
    Reply With Quote Reply With Quote
  3. 02-15-2002, 02:07 PM #3
    akwete
    akwete is offline Member
    Join Date
    Dec 2001
    Location
    Atlanta
    Posts
    175
    Thanks Jeff.

    Our Web Developer wrote a javascript function that took care of it.
    Reply With Quote Reply With Quote
  4. 02-15-2002, 02:56 PM #4
    marist89's Avatar
    marist89
    marist89 is offline Super-Genius
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    Nothing like writing code for something that already exists!
    Jeff Hunter
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules

Click Here to Expand Forum to Full Width