Radicore Forum: Bug Reports » Error with date field

Home » RADICORE development » Bug Reports » Error with date field

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Re: Error with date field [message #7822 is a reply to message #7821]

Tue, 28 March 2023 04:40

AJM
Messages: 2369
Registered: April 2006
Location: Surrey, UK

Senior Member

I would suggest that you ask this question in a MySQL forum. You might want to check the MySQL manual in The DATE, DATETIME, and TIMESTAMP Types where it says:
Quote:

Invalid DATE, DATETIME, or TIMESTAMP values are converted to the "zero" value of the appropriate type ('0000-00-00' or '0000-00-00 00:00:00'), if the SQL mode permits this conversion. The precise behavior depends on which if any of strict SQL mode and the NO_ZERO_DATE SQL mode are enabled; see Section 5.1.11, "Server SQL Modes".

Tony Marston
http://www.tonymarston.net
http://www.radicore.org

Report message to a moderator

[Message index]

		Error with date field By: htManager on Tue, 28 February 2023 06:01
		Re: Error with dictionary import By: AJM on Tue, 28 February 2023 07:02
		Re: Error with dictionary import By: htManager on Wed, 01 March 2023 12:30
		Re: Error with dictionary import By: AJM on Wed, 01 March 2023 13:11
		Re: Error with dictionary import By: htManager on Wed, 01 March 2023 16:55
		Re: Error with dictionary import By: AJM on Thu, 02 March 2023 04:42
		Re: Error with dictionary import By: htManager on Thu, 02 March 2023 12:22
		Re: Error with dictionary import By: AJM on Fri, 03 March 2023 04:42
		Re: Error with dictionary import By: htManager on Tue, 07 March 2023 18:16
		Re: Error with date field By: htManager on Thu, 23 March 2023 10:51
		Re: Error with date field By: AJM on Fri, 24 March 2023 05:28
		Re: Error with date field By: htManager on Fri, 24 March 2023 11:40
		Re: Error with date field By: AJM on Sat, 25 March 2023 05:27
		Re: Error with date field By: htManager on Sat, 25 March 2023 06:58
		Re: Error with date field By: htManager on Sat, 25 March 2023 08:02
		Re: Error with date field By: AJM on Sun, 26 March 2023 04:16
		Re: Error with date field By: htManager on Sun, 26 March 2023 05:29
		Re: Error with date field By: AJM on Mon, 27 March 2023 04:45
		Re: Error with date field By: htManager on Mon, 27 March 2023 05:18
		Re: Error with date field By: AJM on Tue, 28 March 2023 04:40
		Re: Error with date field By: htManager on Fri, 31 March 2023 12:49
		Re: Error with date field By: AJM on Sat, 01 April 2023 04:50
		Re: Error with date field By: htManager on Sat, 01 April 2023 09:00
		Re: Error with date field By: AJM on Sun, 02 April 2023 04:43
		Re: Error with date field By: htManager on Sun, 02 April 2023 05:29
		Re: Error with date field By: AJM on Mon, 03 April 2023 04:37
		Re: Error with date field By: htManager on Mon, 03 April 2023 09:09
		Re: Error with date field By: AJM on Tue, 04 April 2023 04:44
		Re: Error with date field By: htManager on Wed, 05 April 2023 09:48

Previous Topic:	PHP 8 - ListViewPrintAfter()
Next Topic:	File classes/mnu_chart.class.inc is missing

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Mon Nov 25 10:56:45 EST 2024

Total time taken to generate the page: 0.01273 seconds