Click here to Skip to main content
15,848,558 members
Home / Discussions / Database
   

Database

 
AnswerRe: SQL where clause variability up against coding standards Pin
Dave Kreskowiak11-Mar-23 6:37
mveDave Kreskowiak11-Mar-23 6:37 
AnswerRe: SQL where clause variability up against coding standards Pin
Eddy Vluggen11-Mar-23 10:00
professionalEddy Vluggen11-Mar-23 10:00 
AnswerRe: SQL where clause variability up against coding standards Pin
jschell13-Mar-23 7:56
jschell13-Mar-23 7:56 
AnswerRe: SQL where clause variability up against coding standards Pin
jsc4223-Mar-23 8:32
professionaljsc4223-Mar-23 8:32 
GeneralRe: SQL where clause variability up against coding standards Pin
Brian L Hughes23-Mar-23 15:52
Brian L Hughes23-Mar-23 15:52 
GeneralRe: SQL where clause variability up against coding standards Pin
jsc4228-Mar-23 0:00
professionaljsc4228-Mar-23 0:00 
GeneralRe: SQL where clause variability up against coding standards Pin
jschell28-Mar-23 7:23
jschell28-Mar-23 7:23 
QuestionCode: 1292 SQL State: 22007 --- Incorrect datetime value Pin
Siavash.BRY6-Mar-23 21:56
Siavash.BRY6-Mar-23 21:56 
Recently, I migrated from version 5.7.40-0 to version 8.0.31 of MySQL, but I faced the following error message on the columns that are time.

Error :
Code: 1292 SQL State: 22007 --- Incorrect datetime value: '2023-06-31 23:59:00' for column 'date' at row 1


MySQL Query :
SELECT 
	DATE(`Date`) AS `Date`, 
	COUNT(`Date`) AS `Record count` 
FROM tbl_Pw
WHERE `Date` BETWEEN '2023-01-01 00:00:00' AND '2023-03-31 23:59:00'
GROUP BY DATE(`Date`)
ORDER BY `Date`;


How can I fix the problem?
AnswerRe: Code: 1292 SQL State: 22007 --- Incorrect datetime value Pin
Richard MacCutchan6-Mar-23 22:26
mveRichard MacCutchan6-Mar-23 22:26 
GeneralRe: Code: 1292 SQL State: 22007 --- Incorrect datetime value Pin
Siavash.BRY6-Mar-23 22:52
Siavash.BRY6-Mar-23 22:52 
GeneralRe: Code: 1292 SQL State: 22007 --- Incorrect datetime value PinPopular
Richard MacCutchan6-Mar-23 23:09
mveRichard MacCutchan6-Mar-23 23:09 
AnswerRe: Code: 1292 SQL State: 22007 --- Incorrect datetime value Pin
jschell8-Mar-23 8:03
jschell8-Mar-23 8:03 
AnswerRe: Code: 1292 SQL State: 22007 --- Incorrect datetime value Pin
RedDk8-Mar-23 9:30
RedDk8-Mar-23 9:30 
QuestionEF Core 6 Question Pin
Kevin Marois1-Feb-23 17:24
professionalKevin Marois1-Feb-23 17:24 
AnswerRe: EF Core 6 Question Pin
Dave Kreskowiak2-Feb-23 3:34
mveDave Kreskowiak2-Feb-23 3:34 
GeneralRe: EF Core 6 Question Pin
Kevin Marois2-Feb-23 6:45
professionalKevin Marois2-Feb-23 6:45 
Questionexecute an update  using --> "Exec sp_executesql @Sql1" Pin
Member 115338921-Feb-23 5:55
Member 115338921-Feb-23 5:55 
AnswerRe: execute an update  using --> "Exec sp_executesql @Sql1" Pin
Victor Nijegorodov1-Feb-23 6:48
Victor Nijegorodov1-Feb-23 6:48 
AnswerRe: execute an update  using --> "Exec sp_executesql @Sql1" Pin
David Mujica2-Feb-23 5:31
David Mujica2-Feb-23 5:31 
AnswerRe: execute an update  using --> "Exec sp_executesql @Sql1" Pin
Eddy Vluggen10-Mar-23 13:17
professionalEddy Vluggen10-Mar-23 13:17 
QuestionQuestion On SQL Query Result Pin
crmfghtr20-Jan-23 6:13
crmfghtr20-Jan-23 6:13 
AnswerRe: Question On SQL Query Result Pin
Richard Deeming20-Jan-23 6:33
mveRichard Deeming20-Jan-23 6:33 
PraiseRe: Question On SQL Query Result Pin
crmfghtr20-Jan-23 6:41
crmfghtr20-Jan-23 6:41 
AnswerRe: Question On SQL Query Result Pin
Mycroft Holmes20-Jan-23 12:34
professionalMycroft Holmes20-Jan-23 12:34 
GeneralRe: Question On SQL Query Result Pin
crmfghtr20-Jan-23 13:41
crmfghtr20-Jan-23 13:41 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.