By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States.
Privacy

Processing your response...

Discuss This Question: 4 &nbspReplies

There was an error processing your information. Please try again later.

By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States.
Privacy

More details are needed.
Are you using a database block ?
If so, is it based on a table or a query ?
If it is based on a query, you could modify your SELECT statement and use this expression as source for your time item: "to_char(yourColumn,'hh24:mi:ss')".
What exaclty do you mean by "when i update through trigger" ? How are you updating the table(s) ?

I have not created any form yet...but form will be based on database table only...
i want to update through forms the database table....but the problem is that table column is of datatype DATE...it stores both date and time together like '21/04/2010 3:09:00 PM' as told earlier...
so how should i create the form which has both these date n time fields separate??
n i want to update also through this form the time field only in the database but it shouldnt affect the date part in the database....plz reply soon...

-Create a database item for your date field (select DATETIME as the data type for the text item) and use any date-only format mask.
-Create a non-database item for the time
-In the 'POST-QUERY' trigger of the block, put some code like this:

By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States.
Privacy

Processing your reply...

Ask a Question

Free Guide: Managing storage for virtual environments

Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!

To follow this tag...

By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States.
Privacy