| problem in time format in format mask [message #84717] |
Tue, 20 April 2004 08:50  |
Victoria
Messages: 152
Registered: July 2002
|
Senior Member |
|
|
Hi,
I have one text box whose format mask property is set as hh24mi and data type as time.So after entering 2325(valid time format), when messaging the same text box value it displays 84300.But in my table it is of varchar2(4) type.
Please give me the reason why it displays 84300 instead of 2325.
Thanks in Advance
~V~
|
|
|
|
| Re: problem in time format in format mask [message #84720 is a reply to message #84717] |
Tue, 20 April 2004 19:55  |
kiran_jaladi
Messages: 7
Registered: April 2004
|
Junior Member |
|
|
hi,
the problem is in ur table u have the type as varchar2...........
my idea is when u r keeping this text in the text again it is converting that text into again into numbers.
it is ok,wht ever it may,it is considering,wht u do is
dont keep time directly.............
u convert that text into date by using to_char function as like follows...........
to_char(colname,'hh24mi') and then keep in textbox........
hope this may solve ur problem........
--kiran.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
