In message [EMAIL PROTECTED],
Thomas Spahni [EMAIL PROTECTED] writes
On Mon, 26 Nov 2001, Brent wrote:
A Select statement will display the TmeStamp as 2005095105. Now I ask
you, how many users will understand this format?
Why not display TimeStamp in the same format as DateTime? At least
On Mon, 26 Nov 2001, Brent wrote:
A Select statement will display the TmeStamp as 2005095105. Now I ask
you, how many users will understand this format?
Why not display TimeStamp in the same format as DateTime? At least then the
TimeStamp is in a meaningful representation that users
Displaying timestamp columns are a PIK (pain in keester) if you ask me.g
A Select statement will display the TmeStamp as 2005095105. Now I ask
you, how many users will understand this format?
Why not display TimeStamp in the same format as DateTime? At least then the
TimeStamp
Professionals!
I cannot get timestamp to contain a time value different from zero.
According to another mailing this shall happen when something is done wrong
I am completely new to databases. I am initiating the database tables from a php
page.
Can anyone tel me what I am doing wrong??
Thank
with a semi-colon
-Original Message-
From: Olav Drageset [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, November 14, 2001 11:39 AM
To: [EMAIL PROTECTED]
Subject: Timestamp allways zero zero
Professionals!
I cannot get timestamp to contain a time value different from zero.
According to another
On Thursday 15 November 2001 01:38, Olav Drageset wrote:
Professionals!
I cannot get timestamp to contain a time value different from zero.
According to another mailing this shall happen when something is done
wrong I am completely new to databases. I am initiating the database
tables from
Olav Drageset writes:
I cannot get timestamp to contain a time value different from zero.
$tid = NOW(YY-MM-DD HH:MM:SS);
$sql .= VALUES ('$domainName', '$payPerYear', '$nxtPayDay', '$tid',
You're trying to INSERT the string constant 'NOW(YY-MM-DD HH:MM:SS)'
which will be converted
The whole point of a time stamp is that you do NOT insert its value.
Leave it out.
Olav Drageset wrote:
Professionals!
I cannot get timestamp to contain a time value different from zero.
According to another mailing this shall happen when something is done wrong
I am completely new
SMALLINT DEFAULT 0 NOT NULL,
nextPayDay DATE NULL,
members SMALLINT DEFAULT 0 NOT NULL,
noPayMembers SMALLINT DEFAULT 0 NOT NULL,
timeChanged TIMESTAMP (14),
timeCreated TIMESTAMP (14),
INDEX domain(dName));
Which IMHO
I'm curious. Will adding a timestamp field into various tables
that may cause deadlock, prevent the deadlock from happening?
Thanks,
Gisella
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual
Hi all
I'm having a problem getting a query to work where I want to compare the
current_timestamp to the logged timestamp, and return false if less than 300
seconds, can you tell me if it is possible to have the current timestamp
returned as part of a query, so as I can then do my calculations
You can use NOW() to get the current timestamp:
mysql select NOW();
+-+
| NOW() |
+-+
| 2001-10-18 12:49:29 |
+-+
But it would be easier to let MySQL calculate the elapsed time:
select
IF(TIME_TO_SEC(NOW
- Original Message -
From: Torgil Zechel [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, October 18, 2001 11:54 AM
Subject: SV: newbie - questions about timestamp(14)
: You can use NOW() to get the current timestamp:
:
: mysql select NOW();
: +-+
: | NOW
PROTECTED]
Sent: Thursday, October 18, 2001 1:57 PM
Subject: SV: newbie - questions about timestamp(14)
: You seem to miss a comma:
:
: SELECT user_ip, IF(...
: ^^^
:
: -Ursprungligt meddelande-
: Från: p.whiter [mailto:[EMAIL PROTECTED]]
: Skickat: den 18 oktober 2001 14
Thanks for the help everyone. I tried changing the type to timestamp¹ and
that did not fix the problem, however when I changed the type to
int¹ and it worked as it was suppose to.
Thanks,
Lael
Hi everyone,
TIMESTAMP types are supposed to contain millis and even nonos.
How can I ensure these are set, retrieved and used for ORDER BY and
comparisons in MySQL?
I cannot find a way to get even millis back.
Also MySQL does not seem to order by this information. See below example
On Wed, Sep 26, 2001 at 04:53:18PM -0500, Gunter Leeb wrote:
Hi everyone,
TIMESTAMP types are supposed to contain millis and even nonos.
Not according to the documentation.
How can I ensure these are set, retrieved and used for ORDER BY and
comparisons in MySQL?
There is no built-in type
I am running MySQL 3.23.39.
I have a column called added of type timestamp(14)
in a table called users.
I set added to NULL on INSERTs in order to set it to
the current time.
I now want to SELECT all rows added in the last 24
hours.
SELECT * FROM users WHERE added ... ?
What is the correct
I figured out the answer. It is:
SELECT * FROM users WHERE added (CURRENT_TIMESTAMP()
- INTERVAL 24 hour);
--- Andrew Tomazos [EMAIL PROTECTED] wrote:
I am running MySQL 3.23.39.
I have a column called added of type
timestamp(14)
in a table called users.
I set added to NULL
I'm using PHP to add records into a mysql database. The records write
successfully to the database
except for the timestamp field which I have defined as
Field Type Null Key
Default Extra
TheDatetimestamp(14) YES NULL
Kory,
Since your fieldtype for TheDate is timestamp(14), you don't need a
function to insert a timestamp there.
In fact, what you're doing now is inserting the text TIMESTAMP into a date
field, which results in ''
Instead of 'TIMESTAMP', use NULL -- and don't put quotation marks
Omit the value for timestamp. mysql will do all by itself.
Kory Wheatley schrieb am Freitag, 27. Juli 2001, 01:17:22:
I'm using PHP to add records into a mysql database. The records write
successfully to the database
except for the timestamp field which I have defined as
Field Type
hehe, this got rejected because i didn't say
database or sql or query or table
:)
on 7/26/01 5:17 PM, Kory Wheatley at [EMAIL PROTECTED] wrote:
is the TIMESTAMP option where I get the current date from.
try now() instead of TIMESTAMP
-- mike cullerton
-- mike cullerton
Andreas Iwanowski wrote:
How can i fix the problem that the records are ordered by unixtime,
beginning with the newest record ?
http://www.mysql.com/doc/S/E/SELECT.html
--
H | Hi, I'm currently out of my mind. Please leave a message. BP!
Hi everybody,
I am new to the list so if my question was answered recently I do apologize
but I could not find the answer neither in the archive or the manual.
Problem: I try to load data into a table using LOAD DATA LOCAL INFILE.
Into a table containing a TIMESTAMP(14) field. The loading
.
Into a table containing a TIMESTAMP(14) field. The loading works well except
that I don't get the current timestamp in this field no matter if I have
NULL, NULL, or 'NULL' (the same applies to NOW()) I always ending up with
00 in the field.
I am using the current release of MySQL on a Linux
Hello All,
I need to create a database table with a timestamp column data type, but I don't
what it to change each time the row is updated. How can you prevent the
timestamp column from changing each time it's updated.
thanks,
Mike(mickalo)Blezien
MikemickaloBlezien [EMAIL PROTECTED] wrote:
I need to create a database table with a timestamp column data type, but I
don't
what it to change each time the row is updated. How can you prevent the
timestamp column from changing each time it's updated.
Use the DATETIME field type instead
Use one of the other column types, like datetime, instead.
- Original Message -
From: MikemickaloBlezien [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, May 23, 2001 11:37
Subject: timestamp column
Hello All,
I need to create a database table with a timestamp column data
Hello,
The manual says that TIMESTAMP should work. What does this mean? When I
replicate a table with such a field, the values on the slave is
different. Is this OK or a bug?
I'm trying to use this field to avoid data overwrite. In a JSP page I
select a record, read TIMESTAMP field value
Hi,
I have just checked the logs, and the point is that in the update log
there are statements for setting the timestamp, and in the binary log
not.
Is this OK?
Thanks again.
Gabriel
-Original Message-
From: Gabriel Corneanu
Sent: Monday, April 30, 2001 11:23 AM
timestamp value
#--
#--
#--
#--What's the largest possible timestamp value before it rolls over?
#--I'm trying to figure out what's the best way to do the following. I
#--have a table that has these three fields in it:
#--
#--priority int(3)
#--end_time timestamp(14)
#--start_time
how do you query on a TIMESTAMP column to return all records of date today?
I've been using "where date = 20010418 AND date 20010419" syntax
and changing the dates as necessary, but I'd like to replace this
with some kind of today() functio
Andrew Warner wrote:
how do you query on a TIMESTAMP column to return all records of date today?
I've been using "where date = 20010418 AND date 20010419" syntax
and changing the dates as necessary, but I'd like to replace this
with some kind of today() function.
Andrew
What's the largest possible timestamp value before it rolls over?
I'm trying to figure out what's the best way to do the following. I
have a table that has these three fields in it:
priority int(3)
end_time timestamp(14)
start_time timestamp(14)
NOTE: only start_time gets
Is there any way to query a mySQL database for the last time it was updated?
I need this ability to trigger a "restart" in some other applications that
create config files and such for MRTG...
Thanks,
---
Jason H. Frisvold
Senior ATM Engineer
Engineering Dept.
select _timestamp from mytable order by _timestamp desc limit 1;
Jason Frisvold wrote:
Is there any way to query a mySQL database for the last time it was updated?
I need this ability to trigger a "restart" in some other applications that
create config files and such for MRTG...
"Jason Frisvold" [EMAIL PROTECTED] wrote:
Is there any way to query a mySQL database for the last time it was
updated?
I need this ability to trigger a "restart" in some other applications that
create config files and such for MRTG...
Create a field with type DATETIME and update it when a
anged by another
user since you started editing it"
I believe it is due to duplicate timestamp(14) values.
For Example:
I have a simple data base created using the following statement:
create table example (id int(11) NOT NULL AUTO_INCREMENT, name
varchar(10),timestamp timestamp(14),PRIM
Thank you very much -
This works fine now !
Clownfish
- Original Message -
From: "Pat Sherrill" [EMAIL PROTECTED]
To: "Clownfish Internet Services - www.clown-fish.com"
[EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Sunday, February 04, 2001 6:00 PM
Subject: Re:
Description:
There is a _severe_ problem when dealing with "timestamp" column: if I update
a column, also other columns are affected! I enclose a sample script to
show the problem
How-To-Repeat:
create table a(t1 timestamp, t2 timestamp);
insert into a values("2001-01-20",&
Description:
There is a _severe_ problem when dealing with "timestamp" column: if I update
a column, also other columns are affected! I enclose a sample script to
show the problem
How-To-Repeat:
create table a(t1 timestamp, t2 timestamp);
insert into a values("2001-01-20",&
At 12:31 AM -0100 2/2/01, [EMAIL PROTECTED] wrote:
Description:
There is a _severe_ problem when dealing with "timestamp" column: if I update
a column, also other columns are affected! I enclose a sample script to
show the problem
How-To-Repeat:
create table a(t1 timestamp, t2
MySQL always updates the first timestamp column on update, regardless.
-Original Message-
From: Alex Dusty [mailto:[EMAIL PROTECTED]]
Sent: February 1, 2001 7:28 PM
To: [EMAIL PROTECTED]
Subject: Severe problem in handling timestamp column type
Description:
There is a _severe_
Ensure that your TIMESTAMP definition is a TIMESTAMP(14). If it is,
identify which workstations are failing and compare MDAC versions against
those that are not failing (we are using MDAC 2.5 ). Upgrade/downgrade MDAC
as appropriate. In any case, be sure to refresh all the link tables in MS
One of our users is getting the message "another user has changed this
database..etc save changes to clipboard or drop changes... etc",
when he tries to update certain fields in the table. The table has a
timestamp and a primary key. In fact, this user can change certain
file
to update certain fields in the table. The table
has a timestamp and a primary key. In fact, this user can change
certain fileds without difficulty for certain types of data and not
for others (i.e. Access accepts changes when the data is a document
but not when its a collection). To make t
One of our users is getting the message "another user has changed this
database..etc save changes to clipboard or drop changes... etc",
when he tries to update certain fields in the table. The table has a
timestamp and a primary key. In fact, this user can change certain
file
501 - 548 of 548 matches
Mail list logo