Auto inserting DATE/TIME in Forms field

Reply-To: 72072.2122_at_compuserve.com
Sender: 72072.2122_at_compuserve.com

Sorry I can't reply directly to David N McCann, Brunel Univ., West London. I am using a POST-ONLY account.

Re: ** H E L P ** Auto inserting date/Time (SQL*FORMS 2.3)

David N McCann writes:
> (blah) (trying to store time in a forms field)
>:time is the field on the form (and in the table) that I want the
>date and time stored in. Unfortunately this ALWAYS results in the time part
>being set to 00:00:00

A form field may be set to either DATE or DATETIME. DATE will not store the time.
DATETIME will store both date and time.

When selecting field type, try using the list of values.

                                            chicago ,--------+  detroit
Tom Harleman                                        |        |
INOUG Committee Member                              |Indiana |
Paradigm Consulting, Inc.                 st.       | Oracle |
11080 Willowmere Drive                    louis     |  Users |
Indianapolis, IN  46280                             |   Group|
USA                                                 |        |
                                                    |      _,+cincinnati
INTERNET:   72072.2122_at_compuserve.com               /   _,'
Compuserve: 72072,2122                             /_,-'louisville
                                                   `