Re: Last established connection timestamp by a specific user

instance which is currently running on version > `5.7.11-enterprise-commercial-advanced-log`. On this instance I am > trying to figure out the most recent timestamp at which a specific user has > established a connection to this instance (or) performed any DML operations > which mi

Last established connection timestamp by a specific user

Hi, We have a MySQL instance which is currently running on version `5.7.11-enterprise-commercial-advanced-log`. On this instance I am trying to figure out the most recent timestamp at which a specific user has established a connection to this instance (or) performed any DML operations

Re: DATETIME vs CHAR for "timestamp"

> On Apr 14, 2017, at 1:07 PM, shawn l.green wrote: > > That all depends. Do you... Hi Shawn, I thought I had replied to your response, but it looks like I didn’t. Thank you for your email. It was a thorough response and the links were very helpful, as

Re: DATETIME vs CHAR for "timestamp"

On 4/14/2017 3:11 PM, SSC_perl wrote: I have creation date/time fields in my script that are formatted as |MM|DD|hh|mm|ss. Short of changing the script, should I set the field type in MySQL to DATETIME, or would it be better in terms of speed and efficiency to set it as

DATETIME vs CHAR for "timestamp"

I have creation date/time fields in my script that are formatted as |MM|DD|hh|mm|ss. Short of changing the script, should I set the field type in MySQL to DATETIME, or would it be better in terms of speed and efficiency to set it as char(19)? Or would it not make a difference?

Re: Issue with timestamp columns while working with MySQL load data in file

On 2015/04/12 08:52, Pothanaboyina Trimurthy wrote: The problem is , as mentioned the load data is taking around 2 hours, I have 2 timestamp columns for one column I am passing the input through load data, and for the column DB_MODIFIED_DATETIME no input is provided, At the end of the load data

Issue with timestamp columns while working with MySQL load data in file

Hi All, I am facing an issue with timestamp columns while working with MySQL load data in file, I am loading around a million records which is taking around 2 hours to complete the load data. Before get into more details about the problem, first let me share the table structure. CREATE TABLE

Re: Java UTC Calendar and Mysql TimeStamp - Gets me every time!!!!!

On Wed, Aug 21, 2013 at 10:39 PM, h...@tbbs.net wrote: 2013/08/21 18:03 -0400, Nick Khamis We have the following mysql timetampe field startdate | timestamp | NO | | -00-00 00:00:00 When trying to insert a long value in there: Calendar c = Calendar.getInstance

Re: Java UTC Calendar and Mysql TimeStamp - Gets me every time!!!!!

Sorry, as was mentioned earlier: select FROM_UNIXTIME(1377196112065/1000); +---+ | FROM_UNIXTIME(1377196112065/1000) | +---+ | 2013-08-22 18:28:32 | +---+ Have a good day everyone :)

Re: Java UTC Calendar and Mysql TimeStamp - Gets me every time!!!!!

2013/08/22 14:22 -0400, Nick Cameo SimpleDateFormat sdf = new SimpleDateFormat(-MM-dd'T'HH:mm:ss, new Locale(en, US)); Well, you have your answer (FROM_UNIXTIME( /1000)), but that stupid ISO format with 'T' in the middle does not work, because to MySQL letters are not

Java UTC Calendar and Mysql TimeStamp - Gets me every time!!!!!

Hello Everyone, We have the following mysql timetampe field startdate | timestamp | NO | | -00-00 00:00:00 When trying to insert a long value in there: Calendar c = Calendar.getInstance(TimeZone.getTimeZone(UTC)); c.getTimeInMillis(); We are presented with the following error

Re: Java UTC Calendar and Mysql TimeStamp - Gets me every time!!!!!

Nick, You should have answered your own question in the text. The MySql TIMESTAMP type is, as all other timestamps in the *nix world, a count of seconds since epoch time. The Java function you are using yields MILLI-seconds. Divide it by 1000 and you should be good to go. On Wed, Aug 21

Re: Java UTC Calendar and Mysql TimeStamp - Gets me every time!!!!!

2013/08/21 18:03 -0400, Nick Khamis We have the following mysql timetampe field startdate | timestamp | NO | | -00-00 00:00:00 When trying to insert a long value in there: Calendar c = Calendar.getInstance(TimeZone.getTimeZone(UTC)); c.getTimeInMillis(); We are presented

string comparison for timestamp!

at the date-comparisons and wondered how they were done: when I changed the slashes to hyphens it properly worked! I think it would be better if MySQL had real timestamp-constants--and then the separator would matter: colon (and semicolon?) for the sexagesimal part and anything else for the day

Re: Wrong conversion to timestamp from character string

) is an operand to SELECT, and no type is required of it--but the types are not the same, wherefore there is at least one conversion, surely that the bare d is made character string. But it seems that instead TIME(d), a character string, is converted to some timestamp, a date. I wrote that I believe

Timestamp value

When you UPDATE a record, a timestamp field (`t`) is set to the current time in the time zone given by @@time_zone, correct? That will usually be the local time. If somebody in another time zone needs to compare `t` against //their own// local time, they need to use CONVERT_TZ(`t

Re: Timestamp value

Subject: Timestamp value When you UPDATE a record, a timestamp field (`t`) is set to the current time in the time zone given by @@time_zone, correct? That will usually be the local time. If somebody in another time zone needs to compare `t` against //their own// local time, they need to use

RE: Timestamp value

-Original Message- From: Johan De Meersman [mailto:vegiv...@tuxera.be] Sent: Monday, June 06, 2011 12:57 PM To: Jerry Schwartz Cc: mysql@lists.mysql.com Subject: Re: Timestamp value I may be mistaken, but isn't UTC pretty much GMT if you don't want subsecond precision? Set your server's

First and Last timestamp of the day/week / month

I need to be able to get a first and last timestamp for a day a week or a month. I have an example of what I did so far that gets me that info for a week... but I fear that it is far more complex than it needs to be. Anyone have a simple way to get first and last timestamp for these intervals

Re: First and Last timestamp of the day/week / month

You could rewrite it english friendly (5.1.37) SET @DAY_START = curdate(); SET @WEEK_START = curdate() - interval weekday(now()) DAY; SET @MONTH_START = date_format(curdate(), %Y-%m-01); ## DAY SELECT timestamp(@DAY_START) as min_ts, timestamp(@DAY_START + INTERVAL 1 DAY

Creating subsets on timestamp with modulo, date_trunc and ?suggestions?

BY and aggregate An other way I found is described in Celko's 'SQL for smarties'. He uses modulo there. It seems powerful, but also tricky to implement for dates. I was wondering if anyone knew some other way to create a subset of a timestamp column. Any input is welcome. Regards, Davor

Help with Timestamp invalid value error

I run a process which loads a series of timestamped data into a table. I use the TIMESTAMP column. I have a single value with a timestamp of '2008-03-9 2:56:34.737' which fails on insert with 'incorrect datetime'. Days before, and after work. Hours later in the day work. I thought it might

RE: Help with Timestamp invalid value error

What is your sql_mode set to? I tried inserting that value into a timestamp column on our test server and it works fine. Regards John Daisley Mobile +44(0)7812 451238 Email j...@butterflysystems.co.uk Certified MySQL 5 Database Administrator (CMDBA) Certified MySQL 5 Developer Cognos BI

Fwd: Help with Timestamp invalid value error

Currently set to: NO_AUTO_VALUE_ON_ZERO,STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION On Fri, Sep 4, 2009 at 10:24 AM, John Daisleyj...@butterflysystems.co.uk wrote: What is your sql_mode set to? I tried inserting that value into a timestamp column on our test server

RE: Fwd: Help with Timestamp invalid value error

Subject: Fwd: Help with Timestamp invalid value error Currently set to: NO_AUTO_VALUE_ON_ZERO,STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION On Fri, Sep 4, 2009 at 10:24 AM, John Daisleyj...@butterflysystems.co.uk wrote: What is your sql_mode set to? I tried inserting that value

Re: Fwd: Help with Timestamp invalid value error

Administrator (CMDBA) Certified MySQL 5 Developer Cognos BI Developer --- Sent from HP IPAQ mobile device. -Original Message- From: Proemial proem...@gmail.com Sent: Friday, September 04, 2009 3:39 PM To: mysql@lists.mysql.com Subject: Fwd: Help with Timestamp

RE: Fwd: Help with Timestamp invalid value error

with Timestamp invalid value error I had already tried that, actually. Produces the same error. I should have mentioned that as well, sorry! The version is 5.1.34 thanks for the help, btw! Martin On Fri, Sep 4, 2009 at 11:14 AM, John Daisleyj...@butterflysystems.co.uk wrote: Is your table

how to get the timestamp from remote mysql

Hi guys I am going to fetch out the data from remote mysql database according to timestamps colmmen, however my local date is different from the one on remote mysql database, how can I get right timestamp using the date of remote time zone? that is to say I set the date and send itto remote

R: how to get the timestamp from remote mysql

When you are using SQL connected to the server (mysql -ublah) the timestamp is the server one. If you use app time functions it will be client time. Bottom line: use server sql functions. Ciao Claudio Il giorno 4 lug, 2009 8:50 m., Nathan Huang nathan.vorbei.t...@gmail.com ha scritto: Hi guys I

Re: how to get the timestamp from remote mysql

On 4 Jul 2009, at 07:48, Nathan Huang wrote: I am going to fetch out the data from remote mysql database according to timestamps colmmen, however my local date is different from the one on remote mysql database, how can I get right timestamp using the date of remote time zone

Re: how to get the timestamp from remote mysql

Assuming that synchornizing the clocks between the systems is beyond your control you could try getting the UTC timestamp from both systems, then adjust your date/time math according to the difference between them. select unix_timestamp(utc_timestamp()); It is more than a little hacky

Re: Need help to query with timestamp in C++

you are seeking for, I can help with PHP. Saul Kandy Wong wrote: Hi, I need to write a C++ program in a Linux environment to query with a timestamp. The user will only provide with an approximate time so I'd like to know how can I write a program or a query to return the closest data

Re: Need help to query with timestamp in C++

Hi Kandy, this could be the query you are looking for. It should return record with the closest timestamp to your required time: (SELECT TIMEDIFF('20080815091907', timestamp_column) AS diff, t.* FROM table1 t WHERE timestamp_column = '20080815091907' ORDER BY timestamp_column DESC LIMIT 1

Re: Need help to query with timestamp in C++

Kandy Wong wrote: Hi Saul, I need to use C++ and I'm not writing a web application. Thanks anyway. you can do something like: select min(abs(timediff(targettime,timestamp))) from table where condition ; if you use the libmysql you can get the result as strings back (the method i

Re: Need help to query with timestamp in C++

, it saves you from having to do the timestamp string parsing yourself. -- Warren Young, maintainer of MySQL++ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: Need help to query with timestamp in C++

I'm puzzled by the layout of your table, if that's what you're showing us. Is the timestamp in the table truly associated with the time at which the user put in his approximate time? If, for example, the user types in 04:05:07 at 04:03:02, and then types in 04:02:59 at 04:03:03, what

Re: Need help to query with timestamp in C++

Hi Dusan, Thank you so much. It works! Kandy Hi Kandy, this could be the query you are looking for. It should return record with the closest timestamp to your required time: (SELECT TIMEDIFF('20080815091907', timestamp_column) AS diff, t.* FROM table1 t WHERE timestamp_column

Need help to query with timestamp in C++

Hi, I need to write a C++ program in a Linux environment to query with a timestamp. The user will only provide with an approximate time so I'd like to know how can I write a program or a query to return the closest data. The followings are the timestamp in the MySQL database: | 2008-08-05 03:56

Re: Need help to query with timestamp in C++

a C++ program in a Linux environment to query with a timestamp. The user will only provide with an approximate time so I'd like to know how can I write a program or a query to return the closest data. The followings are the timestamp in the MySQL database: | 2008-08-05 03:56:09 | 1217933769

Re: Timestamp and the On Update Current_Timestamp clause

Here is my test. Any way can retrieve the metadata. On Fri, May 9, 2008 at 10:45 PM, Martijn Tonies [EMAIL PROTECTED] wrote: SHOW CREATE TABLE ... Yes, I thought so :-( From a coding point of view, this requires parsing... Why isn't there anything in show full columns. Martijn

Timestamp and the On Update Current_Timestamp clause

Hi, How does one know if ON UPDATE CURRENT_TIMESTAMP was specified when creating a column? How do I retrieve this bit of info from the metadata queries? (also MySQL 4.1) Martijn Tonies Database Workbench - tool for InterBase, Firebird, MySQL, NexusDB, Oracle MS SQL Server Upscene Productions

Re: Timestamp and the On Update Current_Timestamp clause

SHOW CREATE TABLE ... Martijn Tonies wrote: Hi, How does one know if ON UPDATE CURRENT_TIMESTAMP was specified when creating a column? How do I retrieve this bit of info from the metadata queries? (also MySQL 4.1) Martijn Tonies Database Workbench - tool for InterBase, Firebird, MySQL,

Re: Timestamp and the On Update Current_Timestamp clause

SHOW CREATE TABLE ... Yes, I thought so :-( From a coding point of view, this requires parsing... Why isn't there anything in show full columns. Martijn Tonies Database Workbench - tool for InterBase, Firebird, MySQL, NexusDB, Oracle MS SQL Server Upscene Productions

Problems with timestamp and leap seconds?

('val1','PROD1','2005-09-14 15:21:41'); Specifically, the discrepancy appears to be the number of leap seconds that were in effect at the point of the timestamp. E.g., line 697611, characters 15 on: ...sions VALUES ('val2','PROD2','2006-07-31 11:30:57'); ...sions VALUES ('val2

Re: Problems with timestamp and leap seconds?

I had a bit of BFOTO and tried simple inserts. mysql create table t (f timestamp); Query OK, 0 rows affected (0.00 sec) mysql insert into t values ('2008-03-04 16:17:00'); Query OK, 1 row affected (0.00 sec) mysql select * from t; +-+ | f

RE: Problems with timestamp and leap seconds?

[snip] I had a bit of BFOTO and tried simple inserts. mysql create table t (f timestamp); Query OK, 0 rows affected (0.00 sec) mysql insert into t values ('2008-03-04 16:17:00'); Query OK, 1 row affected (0.00 sec) mysql select * from t

RE: Problems with timestamp and leap seconds?

On Tue, 4 Mar 2008, Jay Blanchard [EMAIL PROTECTED] wrote: [snip] I had a bit of BFOTO and tried simple inserts. mysql create table t (f timestamp); Query OK, 0 rows affected (0.00 sec) mysql insert into t values ('2008-03-04 16:17:00'); Query OK, 1 row affected (0.00 sec

RE: Problems with timestamp and leap seconds?

[snip] The column type needs to be DATETIME. Thank you for pointing me at TIMESTAMP versus DATETIME. I'll read http://dev.mysql.com/doc/refman/4.1/en/date-and-time-types.html thoroughly when I can. Can you give a little more detail as to why DATETIME is necessary? [/snip] It was much too

RE: Problems with timestamp and leap seconds?

On Tue, 4 Mar 2008, Jay Blanchard [EMAIL PROTECTED] wrote: It was much too quick a reply on my part but it is my understanding that a TIMESTAMP field is updated according to server time and you cannot actually insert a value. I may be wrong as I have never tested this. Even in pre-4.1 versions

repost timestamp for update insert

i asked this question before, but when i tried what D.Vin suggested, i got an error. mysql version is 4.1.12 i tried: CREATE TABLE tbl_spdate( spdate_ID int NOT NULL PRIMARY KEY AUTO_INCREMENT , spdate_date date NOT NULL , spdate_notes varchar( 100 ) , spdate_created timestamp default 0

RE: repost timestamp for update insert

Your missing your data type for the spdate_updated attribute CREATE TABLE tbl_spdate( spdate_ID int NOT NULL PRIMARY KEY AUTO_INCREMENT , spdate_date date NOT NULL , spdate_notes varchar( 100 ) , spdate_created timestamp default 0, spdate_updated timestamp default CURRENT_TIMESTAMP ON UPDATE

RE: repost timestamp for update insert

- From: Hiep Nguyen [mailto:[EMAIL PROTECTED] Sent: Thursday, November 29, 2007 10:24 AM To: mysql@lists.mysql.com Subject: repost timestamp for update insert i asked this question before, but when i tried what D.Vin suggested, i got an error. mysql version is 4.1.12 i tried: CREATE

Problem with mysqlimport and timestamp

to do this given the format of my $filename. As a check, I tried inserting a row at the top of $filename like test The row was imported correctly, as in there was a NULL in the timestamp column in the database, as well as a NULL in the next column in the database. So, this may have something

Re: Problem with mysqlimport and timestamp

. I'm not sure how to do this given the format of my $filename. As a check, I tried inserting a row at the top of $filename like test The row was imported correctly, as in there was a NULL in the timestamp column in the database, as well as a NULL in the next column in the database. So, this may

timestamp for update and insert

Hi list, i tried to create a table with inserted lastupdated timestamp fields: create table temp ( id int not null primary ke auto_increment, data varchar(100), inserted timestamp default now(), lastupdated timestamp(8)); how do i get mysql to put in the current timestamp for inserted

Re: timestamp for update and insert

I would use a trigger (at least for the update) The first insert should work with now() and you can leave lastupdateted empty Olaf On 9/4/07 3:01 PM, Hiep Nguyen [EMAIL PROTECTED] wrote: Hi list, i tried to create a table with inserted lastupdated timestamp fields: create table

Re: timestamp for update and insert

for the update) The first insert should work with now() and you can leave lastupdateted empty Olaf On 9/4/07 3:01 PM, Hiep Nguyen [EMAIL PROTECTED] wrote: Hi list, i tried to create a table with inserted lastupdated timestamp fields: create table temp ( id int not null

Re: timestamp for update and insert

tried to create a table with inserted lastupdated timestamp fields: create table temp ( id int not null primary ke auto_increment, data varchar(100), inserted timestamp default now(), lastupdated timestamp(8)); how do i get mysql to put in the current timestamp for inserted lastupdated

Re: timestamp for update and insert

timestamp fields: create table temp ( id int not null primary ke auto_increment, data varchar(100), inserted timestamp default now(), lastupdated timestamp(8)); how do i get mysql to put in the current timestamp for inserted lastupdated fields when i insert a record and only lastupdated when i update

Re: timestamp for update and insert

There is nothing terribly wrong with the approach documented in 'http://sql-info.de/mysql/examples/CREATE-TABLE-examples.html' but, as you no doubt have read, it does mean that you have to make sure that every insert statement is specifically designed to set the *second* timestamp field to now

RE: timestamp for update and insert

Just do this... create table temp ( id int not null primary key auto_increment, data varchar(100), inserted timestamp default 0, lastupdated default CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP ); And just use Insert into temp (inserted ) values (NOW()); You're only inserting once, so

Re: timestamp for update and insert

so, if trigger is used then create table temp ( id int not null primary key auto_increment, data varchar(100), inserted timestamp, lastupdated timestamp) is good enough, right? trigger will use now() function to set inserted lastupdated. any thought on backup restore tables tringgers

Re: timestamp for update and insert

[EMAIL PROTECTED] wrote: so, if trigger is used then create table temp ( id int not null primary key auto_increment, data varchar(100), inserted timestamp, lastupdated timestamp) is good enough, right? trigger will use now() function to set inserted lastupdated. any thought

Re: General Query Log -- No Timestamp

On 6/26/07, Brown, Charles [EMAIL PROTECTED] wrote: The MYSQL general query log does not include timestamp of queries that it logs because queries are logged many many seconds before they are executed. Which version of MySQL are you running? I'm running 5.0.22 on my desktop, but I'm fairly

General Query Log -- No Timestamp

The MYSQL general query log does not include timestamp of queries that it logs because queries are logged many many seconds before they are executed. Can someone help me associated queries found in the query log with wall clock? I am trying to get a list of queries that were executed within

Avoiding TIMESTAMP

of payment, etc. and another TIMESTAMP field that stores the date and time. One of the fields contains the username for who received the payment and it is stored automatically by the software, so I can know who processed the payment, when, and all related information... In the first stage

RE: Avoiding TIMESTAMP

-Original Message- From: Miguel Cardenas [mailto:[EMAIL PROTECTED] Sent: Saturday, May 26, 2007 8:21 AM To: mysql@lists.mysql.com Subject: Avoiding TIMESTAMP Hello list I need to solve a little problem but don't mind how, maybe you could suggest something. I have a database

problem with timestamp data type

Hi to all, I have a strange error on using of timestamp data type. See the follow table definition and insert command. DROP TABLE IF EXISTS Storicocorrenti; CREATE TABLE Storicocorrenti ( ID_LINEA mediumint(6) unsigned zerofill NOT NULL default '00', DATAORA timestamp NOT NULL default

Re: problem with timestamp data type

Hello Allesandro, Alessandro Agostini wrote: Hi to all, I have a strange error on using of timestamp data type. See the follow table definition and insert command. DROP TABLE IF EXISTS Storicocorrenti; CREATE TABLE Storicocorrenti ( ID_LINEA mediumint(6) unsigned zerofill NOT NULL default

Re: problem with timestamp data type

Hi Alessandro, all ! Baron Schwartz wrote: Hello Allesandro, Alessandro Agostini wrote: [[...]] Watching the table content, I see second record as: 032100, '2005-03-27 03:00:00', 0, '40.00', '0.000', '0.000', 0, '0.00' MySql change the time information of DATAORA field from 02:00:00

RE: problem with timestamp data type

Maybe, it has to do with the TIMESTAMP behavior: whenever you insert a TIMESTAMP value MySQL converts it to UTC and converts it back to local time (or the time you entered). To prevent this behavior you can - change TIMESTAMP into DATETIME or - disable it by adding this setting to the MY.INI

Re: string to timestamp conversion

May 2007 12:08:11 To:MySQL General mysql@lists.mysql.com Subject: string to timestamp conversion I have a table with a varchar column that contains a timestamp like this: 'Thu May 17 09:15:47 2007' I need to grab this and include it in an insert sql that puts that value in a table

string to timestamp conversion

I have a table with a varchar column that contains a timestamp like this: 'Thu May 17 09:15:47 2007' I need to grab this and include it in an insert sql that puts that value in a table as a timestamp... -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe

Re: string to timestamp conversion

Have you considered using the string to time function? Sent via BlackBerry from T-Mobile -Original Message- From: Bryan Cantwell [EMAIL PROTECTED] Date: Mon, 21 May 2007 12:08:11 To:MySQL General mysql@lists.mysql.com Subject: string to timestamp conversion I have a table

RE: string to timestamp conversion

I see no string to date function that does this conversion... -Original Message- From: Bryan Cantwell Sent: Monday, May 21, 2007 2:08 PM To: MySQL General Subject: string to timestamp conversion I have a table with a varchar column that contains a timestamp like this: 'Thu May 17 09

RE: string to timestamp conversion

Take a look at the following: http://dev.mysql.com/doc/refman/5.0/en/date-and-time-functions.html#func tion_unix-timestamp That looks like exactly what you need... thnx, Chris -Original Message- From: Bryan Cantwell [mailto:[EMAIL PROTECTED] Sent: Monday, May 21, 2007 4:45 PM

Re: How to replicate a timestamp field

in slave server, the timestamp value will b= e different of the master server one. No, it will not be a different value. The replicated query is preceded by SET TIMESTAMP statement which informs slave of the execution time on the master server. If row-based replication is enabled, the problem does

How to replicate a timestamp field

Hello. I know that when a timestamp field has default current_timestamp on update current_timestamp, it will be updated for each update. Question: I have a slave server which replicate this field (The master is deployed Europe and the slave in Brazil). The time of fly to replicate the query

Re: Cannot convert value '0000-00-00 00:00:00' from column 4 to TIMESTAMP

The second major problem I am running into after the upgrade is the following error, which did not occur on Development. Error Executing Database Query. Cannot convert value '-00-00 00:00:00' from column 4 to TIMESTAMP. The error occurred on line 8. MySQL version is: 5.0.27 Thanks

RE: Cannot convert value '0000-00-00 00:00:00' from column 4 to TIMESTAMP

: Cannot convert value '-00-00 00:00:00' from column 4 to TIMESTAMP The second major problem I am running into after the upgrade is the following error, which did not occur on Development. Error Executing Database Query. Cannot convert value '-00-00 00:00:00' from column 4 to TIMESTAMP

RE: Cannot convert value '0000-00-00 00:00:00' from column 4 to TIMESTAMP

I'm simply executing a SELECT query that used to work before, same database, everything the same except a higher version of the MySQL server. In that case you are probably facing some uncompatible issue between the versions you used. Maybe someone else is able to help you more that I :(

RE: Cannot convert value '0000-00-00 00:00:00' from column 4 to TIMESTAMP

This is because with version 4.1 and higher the format of timestamp changes to -00-00 00:00:00. We had this problem, so we had to add a few lines in the scripts that take this field and work with it -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe

RE: Cannot convert value '0000-00-00 00:00:00' from column 4 to TIMESTAMP

Subject: RE: Cannot convert value '-00-00 00:00:00' from column 4 to TIMESTAMP This is because with version 4.1 and higher the format of timestamp changes to -00-00 00:00:00. We had this problem, so we had to add a few lines in the scripts that take this field and work with it -- MySQL General

Cannot convert value '0000-00-00 00:00:00' from column 4 to TIMESTAMP

The second major problem I am running into after the upgrade is the following error, which did not occur on Development. Error Executing Database Query. Cannot convert value '-00-00 00:00:00' from column 4 to TIMESTAMP. The error occurred on line 8. MySQL version is: 5.0.27 Thanks

upgrading from mysql 4.0 to 4.1 : TIMESTAMP OTHER FEATURES

Hi! I would like to upgrade the database of my organisation from mysql4.0.22 from 4.1. We use Debian. I've read info in the manual, but i don't have things clear. We process data of DB with scripts, and I'm annoyed because the change of format of timestamp, is there any command in 4.1 to obtain

Re: upgrading from mysql 4.0 to 4.1 : TIMESTAMP OTHER FEATURES

Regarding the format of TIMESTAMP columns, one of the user comments on http://dev.mysql.com/doc/refman/4.1/en/timestamp-4-1.html offers the solution below: Posted by Kjell Arne Rekaa on April 14 2005 11:11pm If you want the same view of a timestamp field in 4.1.x as it was in in earlier mysql

Is a set current TIMESTAMP operation atomic when updating/inserting multiple rows?

Hi. I want to insert/update multiple rows into a table which has a timestamp field, and I want to set the timestamp field in each row to the current timestamp. However, it is important to me that all the rows I update actually end up with the same timestamp value. My concern is: what happens

Re: Is a set current TIMESTAMP operation atomic when updating/inserting multiple rows?

Dan Jakubiec wrote: Hi. I want to insert/update multiple rows into a table which has a timestamp field, and I want to set the timestamp field in each row to the current timestamp. However, it is important to me that all the rows I update actually end up with the same timestamp value. My

Re: Is a set current TIMESTAMP operation atomic when updating/inserting multiple rows?

Ah, thanks Chris. I should have looked there (I was studying the TIMESTAMP sections, not NOW()). The NOW() documentation also refers to the SYSDATE() function which does the opposite (i.e. sets the time when the record actually gets added). So I'll go ahead and use the 'my_timestamp=NOW

Re: Is a set current TIMESTAMP operation atomic when updating/inserting multiple rows?

mysql@lists.mysql.com Sent: Monday, July 24, 2006 1:11 AM Subject: Re: Is a set current TIMESTAMP operation atomic when updating/inserting multiple rows? Dan Jakubiec wrote: Hi. I want to insert/update multiple rows into a table which has a timestamp field, and I want to set the timestamp

Re: automatic timestamp

', bid_date TIMESTAMP, PRIMARY KEY (bid_id), UNIQUE KEY proj_prop (bid_proj_name,bid_prop_name) ) TYPE=MyISAM; and I am trying toload a file with the following data: ,Construction Management,RCG Consulting,,Orly-Belle ,Construction Management,RCG Consulting,,American Engineers

Re: automatic timestamp

'', bid_sub_amount varchar(20) NULL default '', bid_winner tinyint(1) NOT NULL default '0', bid_date TIMESTAMP, PRIMARY KEY (bid_id), UNIQUE KEY proj_prop (bid_proj_name,bid_prop_name) ) TYPE=MyISAM; and I am trying toload a file with the following data: ,Construction Management,RCG Consulting

automatic timestamp

default '', bid_sub_desc varchar(100) default '', bid_sub_amount varchar(20) NULL default '', bid_winner tinyint(1) NOT NULL default '0', bid_date TIMESTAMP, PRIMARY KEY (bid_id), UNIQUE KEY proj_prop (bid_proj_name,bid_prop_name) ) TYPE=MyISAM; and I am trying toload a file

Re: automatic timestamp

(100) NOT NULL default '', bid_sub_desc varchar(100) default '', bid_sub_amount varchar(20) NULL default '', bid_winner tinyint(1) NOT NULL default '0', bid_date TIMESTAMP, PRIMARY KEY (bid_id), UNIQUE KEY proj_prop (bid_proj_name,bid_prop_name) ) TYPE=MyISAM; and I am

Re: automatic timestamp

varchar(100) NOT NULL default '', bid_sub_desc varchar(100) default '', bid_sub_amount varchar(20) NULL default '', bid_winner tinyint(1) NOT NULL default '0', bid_date TIMESTAMP, PRIMARY KEY (bid_id), UNIQUE KEY proj_prop (bid_proj_name,bid_prop_name) ) TYPE=MyISAM; and I am trying toload a file

update problem with timestamp columns

Hi, I have a table with a time stamp column defined as ts timestamp(14) NOT NULL this is the first timestamp value in a series of timestamp columns. Whenever I update a row in the table ts gets updated with the current timestamp. I read from the documentaion that the first timestamp column

Fwd: update problem with timestamp columns

Did you successfully alter the table? What does SHOW CREATE TABLE give you? mysql CREATE TABLE test ( id INT(10) UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY, ts_create TIMESTAMP DEFAULT CURRENT_TIMESTAMP, ts_modify TIMESTAMP ); Query OK, 0 rows affected (0.00 sec) mysql insert into test(id

I Have Problem with this Timestamp

Hi MySql Community, I put up a default null value TIMESTAMP on field type TIMESTAMP. Now I enter to the database as '-00-00 00:00:00' default for null value. From this on, I mapped it using hibernate with mysql-connector-java-3.1.6-bin.jar driver. I extract it but error occurred: Caused

timestamp not null

Hi! I created a table and, into it, a timestamp field: ... EXPIRES TIMESTAMP NOT NULL, ... When I issue the command describe it shows the field expires allows nulls and defaults to CURRENT_TIMESTAMP. Also, each time I update a field other than expires in this table, expires gets updated

Re: timestamp not null

Hi, I created a table and, into it, a timestamp field: ... EXPIRES TIMESTAMP NOT NULL, ... When I issue the command describe it shows the field expires allows nulls and defaults to CURRENT_TIMESTAMP. Also, each time I update a field other than expires in this table, expires gets updated

  1   2   3   4   5   6   >