Welcome! Log In Create A New Profile

Advanced

WB23 - DateTime field problem???

Posted by infos 
WB23 - DateTime field problem???
December 20, 2021 01:45PM
Hello everyone

I have a website (webdev on php platform)
I have a DateTime field in the tables no matter how I set the date and time format, the DateTime field is always empty (1000-00-00 00:00:00) ??
I write in the way Date_field = Date + Time

collation = utf8_general_ci

Where can my problem be?

[infosonline.net]



Edited 1 time(s). Last edit at 12/20/2021 01:47PM by infos.
pao
Re: WB23 - DateTime field problem???
December 20, 2021 02:31PM
The problem is in the content of the DB tables? what type of DB?
The problem is in the content of the control in the page?

What are date & time in the line Date_field = Date + Time? are you refernig datesys() + timesys()
If you run in debug what is the content of Date_field ?

Regards

Paulo Oliveira
Re: WB23 - DateTime field problem???
December 21, 2021 09:01AM
Hello Pao

The database is MySQL InoDB.
I tried all available date and time formats
My database is on a Linux server in the cloud

[infosonline.net]
Author:

Your Email:


Subject:


Spam prevention:
Please, enter the code that you see below in the input field. This is for blocking bots that try to post this form automatically. If the code is hard to read, then just try to guess it right. If you enter the wrong code, a new image is created and you get another chance to enter it right.
Message: