CodeCharge Studio
search Register Login  

Visual PHP Web Development

Visually Create Internationalized Web Applications, Web Reports, Calendars, and more.
CodeCharge.com

YesSoftware Forums -> Archive -> GotoCode Archive

 Help with Date type

Print topic Send  topic

Author Message
Alex LL
Posted: 05/08/2002, 1:28 AM

Hello,
I've a timestamp column in a PgSql db.
In the corresponding CC record form field I've set
=Date("d.m.Y, G:i")
as default value and Date as data type.
Html checkbox is unchecked.
Inserting a new record results in an empty date field. What is wrong?

Thanks
Alex LL
Nicole
Posted: 05/08/2002, 5:39 AM

Alex,
most probably PostgerSQL doesn't accept date of such format. Note, that you should enter date into db in db date format.
Brent
Posted: 05/08/2002, 7:09 AM

Have you tried setting the Timestamp to NULL? If it is like MySQL, this sets it
to the current date and time. (I'm assuming this is what you want to do).

   


These are Community Forums for users to exchange information.
If you would like to obtain technical product help please visit http://support.yessoftware.com.

Internet Database

Visually create Web enabled database applications in minutes.
CodeCharge.com

Home   |    Search   |    Members   |    Register   |    Login


Powered by UltraApps Forum created with CodeCharge Studio
Copyright © 2003-2004 by UltraApps.com  and YesSoftware, Inc.