| time format [message #228092] |
Sat, 31 March 2007 09:21  |
kris.c
Messages: 1
Registered: March 2007
|
Junior Member |
|
|
|
I am trying to generate a software that used VB as the front end and Oracle 10G as the back end. I have noticed that the date format is VB is : m/dd/yyyy whereas the date format in oracle is dd-mm-yyyy. Whenever i try to insert a tuple with either of the date formats, the program halts running and after a long time , i get a message saying a deadlock was encountered. I have never had any formal introduction to either of the two tools, so, its quite possible that i am missing something quite trivial here.. any help appreciated.
|
|
|
|
|
|
| Re: time format [message #228327 is a reply to message #228092] |
Mon, 02 April 2007 09:54  |
Ronald Beck
Messages: 121
Registered: February 2003
|
Senior Member |
|
|
You should also review the various date formats you can use when you enter a date into Oracle. If you're going to send a date string (it's a character string, not a date number as Oracle understands it), you need to tell Oracle what format your string is in so Oracle can translate the string into a DATE type. For example...
insert into myTable (today_is) values (to_date('02-APR-2007', 'DD-MON-RRRR'));
insert into myTable (today_is) values (to_date('04/02/2007','MM/DD/RRRR'));
insert into myTable (today_is) values (to_date('04/02/2007 14:34:00','MM/DD/RRRR HH24:MI:SS'));
If this information doesn't make sense, go back and look up the to_date SQL function.
HTH,
Ron
|
|
|
|
| Re: time format [message #228329 is a reply to message #228327] |
Mon, 02 April 2007 09:59 |
Frank
Messages: 7901
Registered: March 2000
|
Senior Member |
|
|
There is no need to use RRRR if you provide four digits. (I don't expect your application to fail over the Y10k bug.
So, in my opinion, the correct date-format would be 'DD-MON-YYYY' or 'DD-MM-YYYY' or whatever.
|
|
|
|
| Re: time format [message #228335 is a reply to message #228329] |
Mon, 02 April 2007 10:30 |
Ronald Beck
Messages: 121
Registered: February 2003
|
Senior Member |
|
|
Either format will work for 4 digit years. I'm in the habit of using RRRR so that if I ever need the format 04/23/07, I'll enter MM/DD/RR rather than MM/DD/YY, which would enter 0007 as the year.
I agree that either will work with a 4 digit year. my discipline in coding dictates the use of RRRR as a more exact choice. Your mileage may vary. I've been burned too many times with a date of 06-JAN-0007 because of a bad input format.
Ron
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
