Re: Timestamp Error

2021-08-30 Thread Christopher Schultz
Terrence and Jerry, On 8/27/21 21:33, Terence M. Bandoian wrote: On 8/27/2021 2:31 PM, Jerry Malcolm wrote: On 8/27/2021 1:30 PM, Mark Eggers wrote: On 8/27/2021 11:16 AM, Jerry Malcolm wrote: On 8/27/2021 11:55 AM, Christopher Schultz wrote: Mark and Jerry, On 8/26/21 22:03, Mark Eggers

Re: Timestamp Error

2021-08-27 Thread Terence M. Bandoian
On 8/27/2021 2:31 PM, Jerry Malcolm wrote: On 8/27/2021 1:30 PM, Mark Eggers wrote: On 8/27/2021 11:16 AM, Jerry Malcolm wrote: On 8/27/2021 11:55 AM, Christopher Schultz wrote: Mark and Jerry, On 8/26/21 22:03, Mark Eggers wrote: Jerry, On 8/26/2021 6:35 PM, Jerry Malcolm wrote: I am enc

Re: Timestamp Error

2021-08-27 Thread Christopher Schultz
Jerry, On 8/27/21 14:16, Jerry Malcolm wrote: On 8/27/2021 11:55 AM, Christopher Schultz wrote: Mark and Jerry, On 8/26/21 22:03, Mark Eggers wrote: Jerry, On 8/26/2021 6:35 PM, Jerry Malcolm wrote: I am encountering a weird problem. I'm getting the following SQL error on an INSERT command

Re: Timestamp Error

2021-08-27 Thread Christopher Schultz
Jerry, On 8/27/21 14:16, Jerry Malcolm wrote: On 8/27/2021 11:55 AM, Christopher Schultz wrote: Mark and Jerry, On 8/26/21 22:03, Mark Eggers wrote: Jerry, On 8/26/2021 6:35 PM, Jerry Malcolm wrote: I am encountering a weird problem. I'm getting the following SQL error on an INSERT command

Re: Timestamp Error

2021-08-27 Thread Jerry Malcolm
On 8/27/2021 1:30 PM, Mark Eggers wrote: On 8/27/2021 11:16 AM, Jerry Malcolm wrote: On 8/27/2021 11:55 AM, Christopher Schultz wrote: Mark and Jerry, On 8/26/21 22:03, Mark Eggers wrote: Jerry, On 8/26/2021 6:35 PM, Jerry Malcolm wrote: I am encountering a weird problem. I'm getting the f

Re: Timestamp Error

2021-08-27 Thread Mark Eggers
On 8/27/2021 11:16 AM, Jerry Malcolm wrote: On 8/27/2021 11:55 AM, Christopher Schultz wrote: Mark and Jerry, On 8/26/21 22:03, Mark Eggers wrote: Jerry, On 8/26/2021 6:35 PM, Jerry Malcolm wrote: I am encountering a weird problem. I'm getting the following SQL error on an INSERT command.

Re: Timestamp Error

2021-08-27 Thread Jerry Malcolm
On 8/27/2021 11:55 AM, Christopher Schultz wrote: Mark and Jerry, On 8/26/21 22:03, Mark Eggers wrote: Jerry, On 8/26/2021 6:35 PM, Jerry Malcolm wrote: I am encountering a weird problem. I'm getting the following SQL error on an INSERT command. com.mysql.cj.jdbc.exceptions.MysqlDataTrunc

Re: Timestamp Error

2021-08-27 Thread Christopher Schultz
Mark and Jerry, On 8/26/21 22:03, Mark Eggers wrote: Jerry, On 8/26/2021 6:35 PM, Jerry Malcolm wrote: I am encountering a weird problem. I'm getting the following SQL error on an INSERT command. com.mysql.cj.jdbc.exceptions.MysqlDataTruncation: Data truncation: Incorrect datetime value: '1

Re: Timestamp Error

2021-08-26 Thread Mark Eggers
Jerry, On 8/26/2021 6:35 PM, Jerry Malcolm wrote: I am encountering a weird problem. I'm getting the following SQL error on an INSERT command. com.mysql.cj.jdbc.exceptions.MysqlDataTruncation: Data truncation: Incorrect datetime value: '1969-12-31 18:00:00.0' for column... The column is a TI

Timestamp Error

2021-08-26 Thread Jerry Malcolm
I am encountering a weird problem. I'm getting the following SQL error on an INSERT command. com.mysql.cj.jdbc.exceptions.MysqlDataTruncation: Data truncation: Incorrect datetime value: '1969-12-31 18:00:00.0' for column... The column is a TIMESTAMP in mySQL. I pasted the SQL statement directl