OraFAQ Forum: Forms » entering time in sql by forms

Home » Developer & Programmer » Forms » entering time in sql by forms

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

entering time in sql by forms [message #79503]

Tue, 18 June 2002 00:45

adeel
Messages: 4
Registered: June 2002

Junior Member

i have two field time and date which are part of the key.
both have the datatype of date.
i set the format mask correctly both for time and date.
when i enter or execute the form or make input it show the time but in SQL it dont show the time and show date on both field which cause error.

Report message to a moderator

Re: entering time in sql by forms [message #79505 is a reply to message #79503]

Tue, 18 June 2002 06:12

Subhash
Messages: 105
Registered: October 2001

Senior Member

Set the datatype of the field as 'datetime'

Regards

Report message to a moderator

Previous Topic:	Extracting Trigger Code from Forms.
Next Topic:	Re: EXECUTE_QUERY.........save?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 25 10:33:14 CDT 2024