OraFAQ Forum: Forms » Date in Forms 10g

Home » Developer & Programmer » Forms » Date in Forms 10g

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

Date in Forms 10g [message #209692]

Sun, 17 December 2006 00:41

Aver
Messages: 29
Registered: December 2006

Junior Member

When i save the date in format 'dd/mm/rrrr hh24:mi' from forms i get always 00:00 in database.
What can be a reason for it?

[Updated on: Sun, 17 December 2006 00:42]

Report message to a moderator

Re: Date in Forms 10g [message #209793 is a reply to message #209692]

Sun, 17 December 2006 20:55

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

Define the field as being 'datetime', not just 'date'.

David

Report message to a moderator

Re: Date in Forms 10g [message #209817 is a reply to message #209692]

Mon, 18 December 2006 00:19

Aver
Messages: 29
Registered: December 2006

Junior Member

Thanks.

Report message to a moderator

Re: Date in Forms 10g [message #211539 is a reply to message #209817]

Fri, 29 December 2006 05:12

theusser
Messages: 3
Registered: December 2006
Location: Switzerland

Junior Member

How to do that in Oracle SQL developer? DateTime is missing there ...

Thomas

Report message to a moderator

Re: Date in Forms 10g [message #211547 is a reply to message #211539]

Fri, 29 December 2006 05:50

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

David referred to a field (Forms item) (which should be of a Datetime datatype), not table column (which should be of a Date datatype).

SQL Developer has nothing to do with Forms Builder, so you can't expect it to set datatype in a form. You can, of course, create a table using SQL Developer.

Report message to a moderator

Re: Date in Forms 10g [message #212220 is a reply to message #211539]

Thu, 04 January 2007 04:56

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

Use the 'alter SESSION SET nls_DATE_FORMAT'.

Look at http://www.orafaq.com/forum/m/190310/67467/?srch=alter+nls#msg_190310

David

Report message to a moderator

Previous Topic:	Matrix Form
Next Topic:	How to install Developer 2000/6i in Windows Xp

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Feb 12 23:17:22 CST 2025