Bad date error

sreenisha

HI
Can Anyone help me in correcting the error.I have a datbase in psql which has a date field.While trying to insert it using php form i am getting the error:

Quote:

Warning: pg_query(): Query failed: ERROR: Bad date external representation '' . in
/var/www/html/date.php

But When i try to insert directly from Database it is working.
What may be the problem??Anyone please help.

Thank u in advance.

rski

Are you sure the date format you use in postgres and in the script are the same?

sreenisha

hi some how i managed to correct the date format.Now i have a problem with the phone number field.I have specified while creating the table as phone integer.But when i try to insert a value which has more than 10 digits,it shows error.No validation has done yet.
How can i correct it.

rski

Quote:

Originally Posted by sreenisha

hi some how i managed to correct the date format.Now i have a problem with the phone number field.I have specified while creating the table as phone integer.But when i try to insert a value which has more than 10 digits,it shows error.No validation has done yet.
How can i correct it.

change the column type to varchar(max_number_of_characters) or char(max_number_of_characters)

Bad date error

re: Bad date error

re: Bad date error

re: Bad date error

Similar PostgreSQL Database bytes

/bytes/development

/bytes/it

/bytes/about