I'm using OpenOffice 1.1.0 as a front-end to MySQL 4.0.14 on Gentoo
Linux and can't compare a field to CURDATE(). The error is, "The field
cannot be compared with a date". The column is formatted as a DATE, and
I can perform the compare fine using mysql.
I realize this is prob
rlier values might work, there is
no guarantee that they will.)"
and
"Illegal DATETIME, DATE, or TIMESTAMP values are converted to the
``zero'' value of the appropriate type ('-00-00 00:00:00',
'-00-00', or 00)."
along with the many
At 4:41 PM -0800 10/27/03, bluejack wrote:
On Mon, 27 Oct 2003 18:34:34 -0600, Paul DuBois <[EMAIL PROTECTED]> wrote:
At 5:32 PM -0500 10/27/03, sean peters wrote:
Hi all,
I have run into a date storage problem that i don't like. A am storing
historic house sales, and some of the old
On Mon, 27 Oct 2003 18:34:34 -0600, Paul DuBois <[EMAIL PROTECTED]> wrote:
At 5:32 PM -0500 10/27/03, sean peters wrote:
Hi all,
I have run into a date storage problem that i don't like. A am storing
historic house sales, and some of the old data i have received only contains
the mon
At 5:32 PM -0500 10/27/03, sean peters wrote:
Hi all,
I have run into a date storage problem that i don't like. A am storing
historic house sales, and some of the old data i have received only contains
the month and year, but not the date of the sale. Of course we want to store
this inform
On Mon, 27 Oct 2003 17:58:38 -0500, sean peters <[EMAIL PROTECTED]> wrote:
Well, thats actually what i am going to do. A date column won't take anything
but a valid date (sort of - feb. 30 is "valid").
But i still need to know whether the day of month is meaningful or no
On Mon, Oct 27, 2003 at 05:32:34PM -0500, sean peters wrote:
> Hi all,
> I have run into a date storage problem that i don't like. A am storing
> historic house sales, and some of the old data i have received only contains
> the month and year, but not the date of the sale. Of
Sorry, i wasn't completely clear.
Well, thats actually what i am going to do. A date column won't take anything
but a valid date (sort of - feb. 30 is "valid").
But i still need to know whether the day of month is meaningful or not, for
various search / display purposes. M
what about forcing the date to the first of whatever month the sale was in? if it's
got a valid date, put that, otherwise, put the first.
-Original Message-
From: sean peters [mailto:[EMAIL PROTECTED]
Sent: Monday, October 27, 2003 4:33 PM
To: [EMAIL PROTECTED]
Subject: Unusual
Hi all,
I have run into a date storage problem that i don't like. A am storing
historic house sales, and some of the old data i have received only contains
the month and year, but not the date of the sale. Of course we want to store
this information, but a DATE column won't quite
PROTECTED]
Hi All !
I have a datetime field in a table. When I use insert into table
(aniversary) values ('24/10/2003'). The date is save as 20/10/2024. I am
using dd/mm/ What can I do to save the date correctely ?
best regar
Hi All !
I have a datetime field in a table. When I use insert into table
(aniversary) values ('24/10/2003'). The date is save as 20/10/2024. I am
using dd/mm/ What can I do to save the date correctely ?
best regards,
Eduar
I have a table that contains a date of birth (date) and a age field. How can
I create an update query that would calculate the correct age (from the date
of birth) and update the age field? I tried doing it with php but ran into
problems with persons born before 1969.
thanks,
Luis R. Lebron
At 1:55 +0200 10/17/03, Kim G. Pedersen wrote:
Hello
I looking for a way to convert a datestring to date value
example
UnknowFunction('23.03.68','dd.mm.yy') -> unixtimestamp
In oracle we have
to_date('23.03.68','dd.mm.yy')
I have search the net for h
Me, I will say that such a function should be added as a feature request
since it doesn't exist.
MySQL 4.1.1 introduces MAKE_DATE()
The following can be read from
http://www.mysql.com/doc/en/Date_and_time_functions.html
MAKEDATE(year,dayofyear)
Returns a date, given year and day-of-year v
* Kim G. Pedersen
> I looking for a way to convert a datestring to date value
> example
> UnknowFunction('23.03.68','dd.mm.yy') -> unixtimestamp
>
> In oracle we have
> to_date('23.03.68','dd.mm.yy')
>
> I have search the net
* Kim G. Pedersen
> I looking for a way to convert a datestring to date value
> example
> UnknowFunction('23.03.68','dd.mm.yy') -> unixtimestamp
>
> In oracle we have
> to_date('23.03.68','dd.mm.yy')
>
> I have search the net
Hello
I looking for a way to convert a datestring to date value
example
UnknowFunction('23.03.68','dd.mm.yy') -> unixtimestamp
In oracle we have
to_date('23.03.68','dd.mm.yy')
I have search the net for hours without luck.
Regards
Kim G. Peder
> 1 p1 02032002 12202003
> 2 p2 04012003 10012003
> 3 p3 01012003 12312003
>
>
> COMMENTS
>
> seq date comment
>
> 1 09/15/2002Here is a comment.
> 2 07/09/2003Another comment.
> 2 08/15/2003Seco
10012003
3 p3 01012003 12312003
COMMENTS
seq date comment
1 09/15/2002Here is a comment.
2 07/09/2003Another comment.
2 08/15/2003Second comment for this project.
3 05/15/2003Here is a comment.
I want to join these tables only taking the most
hay ross
i had ot pick up data rows for the dates between from-date and to-date
user selection u know
i went about the problem with a loop .
heres the code
for($loop_mon=$frm_mon; $loop_mon<=$to_mon ; $loop_mon++){
$ftch_rprt_dta_qry = "select sum($rprt_col)
from $
That will only return the number of rows in "Table1" What I want to
return 1 to n rows based on the number of days between date1 and daten
with each row having the date filled in.
Ross Davis
DataAnywhere.net
250-470-9192
ChaletsOnline.com is coming soon
Don't you des
At 12:59 PM 10/10/2003, you wrote:
I want know if there is a way to return every date between 2 date ranges
regardless if there is a row in a table. I have a table that contains
daily pricing information and I want to be able to do a mass
updated/insert records. I know how to write the updates
I want know if there is a way to return every date between 2 date ranges
regardless if there is a row in a table. I have a table that contains
daily pricing information and I want to be able to do a mass
updated/insert records. I know how to write the updates/inserts if I
have table that
Dear all,
anyone knows why the following is going wrong (I expect 1 in the columns Total
and Open)? I suppose it is because MySQL is internally casting the IF
expression (which is DATE vs DATE or DATE vs DATETIME) internally into a
STRING before comparison, but not sure about that
(String
l: NEFACOMP" <[EMAIL PROTECTED]>
To: "Emilio Ruben Estevez" <[EMAIL PROTECTED]>;
<[EMAIL PROTECTED]>
Sent: Thursday, October 02, 2003 22:16
Subject: Re: How can i make mysql to print date and time automatically?
> INSERT INTO your_table (field1, field2, field3) VAL
INSERT INTO your_table (field1, field2, field3) VALUES(DATE(), "value2",
TIME())
But check the manual for very simple things.
Thanks
Emery
- Original Message -
From: "Emilio Ruben Estevez" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, Oct
> I'm running this query:
>
> INSERT INTO `events`( `domain`, `title`, `body`, `begin`, `end`,
> `frequency`, `author` ) VALUES( 01, 'Test 2', 'Event is not displaying
> correct date.', '2003-10-25 24:00:00', '2003-10-01 24:00:00
Hi
I'm running this query:
INSERT INTO `events`( `domain`, `title`, `body`, `begin`, `end`,
`frequency`, `author` ) VALUES( 01, 'Test 2', 'Event is not displaying
correct date.', '2003-10-25 24:00:00', '2003-10-01 24:00:00', '0',
'
On Wed, 2003-10-01 at 10:09, Emilio Ruben Estevez wrote:
> Hi, im develping an application, and was wondering how can i make mysql get
> time and date from pc and print it automatically in the time field and date
> field so the user dont have to worry about entering the coorect time an
Hi, im develping an application, and was wondering how can i make mysql get
time and date from pc and print it automatically in the time field and date
field so the user dont have to worry about entering the coorect time and
date. Is this posible, ive created a databse with fields hour(time
-
From: "Corn Hulio" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.myodbc
Sent: Tuesday, September 30, 2003 7:30 PM
Subject: Approx. Release Date of 5.0?
> Hello,
>
> when is the approx. (very rough) release date of MySQL 5.0? I searched the
> archive but found no s
Hello,
when is the approx. (very rough) release date of MySQL 5.0? I searched the
archive but found no satisfactory answer. I am not interested in an exact
date or month, just a very rough estimate. Will it approx. be in a month,
in a year or in 2 years?
Thank you for your answers!
--
MySQL
At 11:02 -0400 9/27/03, Bruce Therrien wrote:
Using a select statement, how does one
select all records that have a date one day
less than the current date? Searching the archives
and I can't seem to find the answer..
Our database has these fields:
EMAIL, AMOUNT, ID, DATE
The date
Bruce Therrien wrote:
Using a select statement, how does one
select all records that have a date one day
less than the current date?
Our database has these fields:
EMAIL, AMOUNT, ID, DATE
The date is in format 00/00/
Gack. I'm guessing "00/00/" is a string?
1) &q
Using a select statement, how does one
select all records that have a date one day
less than the current date? Searching the archives
and I can't seem to find the answer..
Our database has these fields:
EMAIL, AMOUNT, ID, DATE
The date is in format 00/00/
Thanks
--
Bruce The
"Optik Bacik Scheibbs" <[EMAIL PROTECTED]> wrote:
>
> So this is my first time here...
>
> I am using myODBC 3.51 Server 4.0.14
>
> So I created a table with one columm called "GebDat" - format Date
>
> I connect to this DB using VB6 (SP5)
Hi,
What is the table definition? Have you got a primary index?
I work with date fields without problems in this way:
Update table set Date_Field = '2003-08-01' Where Date_Field = '2003-01-19'
Lourdes.
Optik Bacik Scheibbs escribió:
Hey!
So this is my first time here..
Hey!
So this is my first time here...
I am using myODBC 3.51 Server 4.0.14
So I created a table with one columm called "GebDat" - format Date
I connect to this DB using VB6 (SP5) with ADO.
OK - So when I add a new data it works fine. But when I will update any one data I
always ge
try ISO standard dates MMDD
- Original Message -
From: "Lakshmi Chennareddi" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, September 16, 2003 4:17 PM
Subject: Reading Date from a csv file
: I am new to mySQL.
:
: I am trying to import data from
Try '-mm-dd'.
-Original Message-
From: Lakshmi Chennareddi [mailto:[EMAIL PROTECTED]
Sent: Tuesday, September 16, 2003 10:18 AM
To: [EMAIL PROTECTED]
Subject: Reading Date from a csv file
I am new to mySQL.
I am trying to import data from a csv file, using the following
ate,
field9
);
The data is getting imported, but the dates are wrong.
In the original data file the dates are "mm/dd/yy" format. How do I specify
the date formats, in the code?
Thanks in advance for any help,
Lakshmi
Hi Pete,
Thanks for this info
Regards,
Delz
- Original Message -
From: "Peter Vertes" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Sunday, September 14, 2003 12:05 AM
Subject: Re: Date computation in MySQL & PHP
> On Sat, 2003-09-13 at 02:50,
On Sat, 2003-09-13 at 02:50, delz wrote:
> I want to know how do I use computations on dates in php or mysql like for
> example, today is September 13, 2003 (2003-09-13) and I want to get the date
> output if I add 5 days from the given date so that my output would be
> September 18
Hi All,
I want to know how do I use computations on dates in php or mysql like for
example, today is September 13, 2003 (2003-09-13) and I want to get the date
output if I add 5 days from the given date so that my output would be
September 18, 2003 (2003-09-18). And if any given day falls on a
arrgg, sorry i made a mistake and my precedent mail
was sent before i finished wrting it :-{,
the query is:
INSERT INTO `TBL_COUNT_EXCLUDE`
SELECT MAIN.id, SUM(IF(EX.excl_date BETWEEN
MAIN.start_date AND MAIN.end_date, 1, 0)) AS
excl_count
FROM TBL_MAIN_DATE AS MAIN, TBL_EXCLUDE_DATE AS EX
GROUP
hi all,
i've a question concerning the calculation of the
number of days between 2 dates, and after searching
the mailing list i'm still stuck, any help will be
appreceiated :}
actually i've a table with a lot of rows (varying
between 5 to 15 millions), each row has a uniqu
-10 00:00:00" AND
date_field < DATE_ADD("2003-10-10 00:00:00", INTERVAL 1 DAY);
-JF
> -Original Message-
> From: Terence [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, September 09, 2003 8:21 PM
> To: [EMAIL PROTECTED]
> Subject: MySQL 4.1 Date Comparing
>
>
&
Dear All,
We recently upgraded from 3.23 to 4.1.
We used to use queries such as:
SELECT field FROM table WHERE date_field like '2003-10-10%'
(The date_field is a "datetime" field)
Since we found the performance quicker than using the date functions.
However this no long
* Creative Solutions New Media
> I have a table with a date field (called myDate for example)
> formatted like -xx-xx.
>
> I want to do a query searching for all dates with the month of
> August, for example.
>
> How would I do that?
SELECT datecol FROM mytable WH
Hi,
I have a table with a date field (called myDate for example) formatted like
-xx-xx.
I want to do a query searching for all dates with the month of August, for
example.
How would I do that?
Tim Winters
Manager, Creative Development
Sampling Technologies Incorporated (STI)
[EMAIL
Hans,
the problem is partially fixed in 4.1.1. You get a warning from inserting a
nonsensical date. But it still accepts '1996-02-31' without a warning,
though there are max 29 days in February. I have now notified the developers
about this bug.
Best regards,
Heikki Tuuri
Innoba
Fred van Engen wrote:
> SELECT 2147483648*2147483648*4 returns 0.
> SELECT 2147483648*2147483648*2 returns -9223372036854775808.
> SELECT 2147483648*2147483648*2-1 returns 9223372036854775807.
>
> The same problem in most programming languages. What do other DBMS do
> and what do the SQL stand
On Sat, Aug 23, 2003 at 02:07:36PM +0200, Hans van Harten wrote:
> Fred van Engen wrote:
> > On Sat, Aug 23, 2003 at 10:54:32AM +0200, Hans van Harten wrote:
> >> My checks might not match those of (the next version of) MySQL and
> >> at that time the difference in thoughts will pass unnoticed !
>
Fred van Engen wrote:
> On Sat, Aug 23, 2003 at 10:54:32AM +0200, Hans van Harten wrote:
>> My checks might not match those of (the next version of) MySQL and
>> at that time the difference in thoughts will pass unnoticed !
> I agree that MySQL should complain but I'm not sure it should fail.
> The
On Sat, Aug 23, 2003 at 10:54:32AM +0200, Hans van Harten wrote:
> Fred van Engen wrote:
> > On Fri, Aug 22, 2003 at 01:16:48AM -0500, Hans van Harten wrote:
> >> that comes with neither warnings nor errors reported ...
> > Error reports would have been nice, but why does your application
> > suppl
Fred van Engen wrote:
> On Fri, Aug 22, 2003 at 01:16:48AM -0500, Hans van Harten wrote:
>> that comes with neither warnings nor errors reported ...
> Error reports would have been nice, but why does your application
> supply these incorrect dates anyway? Probably because some user typed
> them. An
Rajesh Kumar wrote:
> Hans van Harten unknowingly asked us:
>
>> create database data_test ;
>> use data_test;
>> create table test3 (a date);
>> insert into test3 values (
>> from_unixtime(unix_timestamp('2002-102-31'),
; SELECT unix_timestamp('2002-02-31');
> > which provides a correct result.
> > Some interesting results:
> > We could then probably eliminate all timestamps stored as 1969-12-31
> > as we know that they're illegal.
> Uh, isn't it an signed integer, thus all
lts:
> We could then probably eliminate all timestamps stored as 1969-12-31
> as we know that they're illegal.
Uh, isn't it an signed integer, thus allowing date before 1970-01-01 too??
Anyway, all this led me towards is:
create database data_test ;
use data_test;
Peter Brawley unknowingly asked us:
Interestingly, use of date_add() and date_sub() on 'odd' dates such as
"Feb 31" does produce sane results.
Subtract one from "2000 Feb 31", and you'll get 2000-03-01.
This is sane!!??
This is where Unix Timestamps come into action (and perhaps rescue)!
To be sur
Kevin Fries wrote:
> I agree it's unfortunate that the dates get stored. But some do seem
> to prefer it this way.
>
> To quote the manual at the bottom of:
> http://www.mysql.com/doc/en/Using_DATE.html
>
> If the date cannot be converted to any reasonable value, a 0 is
>Interestingly, use of date_add() and date_sub() on 'odd' dates such as
>"Feb 31" does produce sane results.
>Subtract one from "2000 Feb 31", and you'll get 2000-03-01.
This is sane!!??
PB
[mysql]
I agree it's unfortunate that the dates get stored. But some do seem to
prefer it this way.
To quote the manual at the bottom of:
http://www.mysql.com/doc/en/Using_DATE.html
If the date cannot be converted to any reasonable value, a 0 is
stored in the DATE field, which will be retr
Adam Clauss and Rajesh Kumar wrote:
>> Hans van Harten unknowingly asked us:
LOL
>>> Some make the laughing stock of MySQL with this code:
>>> create database data_test ;
>>> use data_test;
>>> create table test3 (a date);
>>>
As per the manual that is correct.
The only correct date will be 1996-02-31.
what is the problem?
-Original Message-
From: Hans van Harten [mailto:[EMAIL PROTECTED]
Sent: Thursday, August 21, 2003 4:09 PM
To: [EMAIL PROTECTED]
Subject: MySQL running out of date
Some make the laughing
Same here.
Got 0's for the invalid dates, correct date for the other. What is wrong?
Adam Clauss
[EMAIL PROTECTED]
> -Original Message-
> From: Rajesh Kumar [mailto:[EMAIL PROTECTED]
> Sent: Thursday, August 21, 2003 1:35 PM
> To: Hans van Harten
> Cc: [EMAIL PROT
Hans van Harten unknowingly asked us:
Some make the laughing stock of MySQL with this code:
create database data_test ;
use data_test;
create table test3 (a date);
insert into test3 values (-1);
insert into test3 values ('1996-02-31');
insert into test3 values (&
Some make the laughing stock of MySQL with this code:
create database data_test ;
use data_test;
create table test3 (a date);
insert into test3 values (-1);
insert into test3 values ('1996-02-31');
insert into test3 values ('1996-67-31');
select * f
Hi,
try this:
SELECT * FROM your_table
WHERE StartDate > NOW()
AND EndDate < NOW()
> Hello,
>
> I am having a problem when doing a SELECT. Here is the
> scenerio:
>
> I have a table that has an event StartDate and
> EndDate, based on the current Date "NOW()&quo
SELECT * FROM table_name WHERE EndDate < now();
Is this what you need?
-Original Message-
From: Rob Sirota [mailto:[EMAIL PROTECTED]
Sent: Tuesday, August 19, 2003 4:12 AM
To: [EMAIL PROTECTED]
Subject: Help with SELECT statement for date range
Hello,
I am having a problem when do
On Tue, 19 Aug 2003 04:11:32 -0700 (PDT)
Rob Sirota <[EMAIL PROTECTED]> wrote:
> Hello,
>
> I am having a problem when doing a SELECT. Here is the
> scenerio:
>
> I have a table that has an event StartDate and
> EndDate, based on the current Date "NOW()&quo
Hello,
I am having a problem when doing a SELECT. Here is the
scenerio:
I have a table that has an event StartDate and
EndDate, based on the current Date "NOW()" I need to
know which records are currently active. Can anyone
help with a quick SELECT statemen
- Original Message -
From: "Victoria Reznichenko" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Saturday, August 16, 2003 11:48 AM
Subject: Re: Can I change the date format...
> Karam Chand <[EMAIL PROTECTED]> wrote:
> > Is there any
Karam Chand <[EMAIL PROTECTED]> wrote:
> Is there anyway to change the default date format
> (possibly in a .ini or .cfg file) from -MM-DD to
> another format ? (ie, mm/dd/ or any user-defined
> format).
No, You can't.
>
> The useage that I'm looking a
Hello
Is there anyway to change the default date format
(possibly in a .ini or .cfg file) from -MM-DD to
another format ? (ie, mm/dd/ or any user-defined
format).
The useage that I'm looking at is to import a CSV file
into a table (using Load data infile command)
where date
Is mysql still in business? Their web page is down.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hi All,
I have added the date column ( column name is
dolv ) in mysql as CHAR(10) as I needed the date in
mmdd separated by mm/dd/. Now I want to have
this column contain the date whenever the updation to
that column is done. Please advise as to how I can
achieve this without losing
On 8 Aug 2003 at 10:16, Oswaldo Castro wrote:
> I have two datetime fields on my database. I nedd to return the
> difference in minutes between them. I tried date_sub,
> extract(hour_minute from ...) and it does't work
SELECT ( UNIX_TIMESTAMP(datetime2) - UNIX_TIMESTAMP(datetime1) ) /
60;
(assu
Yes, they are still in business...just having temporary technical
difficulties.
-Original Message-
From: Gilbert Wu [mailto:[EMAIL PROTECTED]
Sent: Wednesday, August 06, 2003 4:31 AM
To: [EMAIL PROTECTED]
Subject: RE: alter date
Is mysql still in business? Their web page is down
e
MySQL assumes the string represents a date-time in the server time
zone. Is your server set to GMT, or is there some summertime
adjustment occurring?
> 2) The function
> from_unixtime(n) wraps on my server after 2^31 seconds. e.g. select
> from_unixtime(2147483648) returns "1900-
ever, the same function gave different
> results a few minutes apart - that's the scary bit.
Sorry, I was confused about the sign of the offset. -3600 is what
you should get if the server is on BST, which is +0100, not -0100
(and +0100 is what your e-mail date says). That still doesn&#x
* Jack Lauman
> I have a table with a column "date" that contains dates in SQL format,
> i.e. 2003-08-10
>
> I need to query the table and return all the rows from the current date
> thru the next 6 days. (i.e. today 2003-08-10 thru Saturday 2003-08-16).
>
> I have
Hi,
1) I was investigating the unix_timestamp routine in mysql (version
3.23.46-nt) and for some reason the unix epoch (1-1-1970) was returned
with a value of -3600. Then, as you can see, it suddenly corrected
itself. I can't replicate this error, but it caused me to shudder.
Attached is the output
> > with a value of -3600.
>
> That's what I'd expect if the time zone was set to -0100, since
> MySQL assumes the string represents a date-time in the server time
> zone. Is your server set to GMT, or is there some summertime
> adjustment occurring?
>
> > 2
Fabio Bernardo wrote:
>
> Hi there,
> Do you know a sql command which I can write to obtain the last date that I
> updated a table
Fabio,
mysql> SHOW TABLE STATUS LIKE 'table_name'
walt
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysq
I have a table with a column "date" that contains dates in SQL format,
i.e. 2003-08-10
I need to query the table and return all the rows from the current date
thru the next 6 days. (i.e. today 2003-08-10 thru Saturday 2003-08-16).
I have tried the following query which returns
Hi List
I have two datetime fields on my database. I nedd to return the difference
in minutes between them. I tried date_sub, extract(hour_minute from ...) and
it does't work
Any help will be very apreciated.
Thanks
Oswaldo Castro
--
MySQL General Mailing List
For list archives: http://lists
* Girish Agarwal
> Hi All,
>I have added the date column ( column name is
> dolv ) in mysql as CHAR(10)
Then it is not a 'date column', but s string column... ;)
See the manual for a description of the different column types:
http://www.mysql.com/doc/en/Colum
ore 2038. For instance, if you need to store
retirement dates, a Unix timestamp would be a bad choice even today.
Of course you wouldn't need a time for a retirement date, and
wouldn't be concerned about time zone or summer adjustments, so a
DATE column would be fine, but people do use
While I don't know for sure, my guess is that it would have something to
do with 32 bit as the magic number, but also...being that this won't
become a problem until
mysql> select from_unixtime(2147483647);
+---+
| from_unixtime(2147483647) |
+---+
|
Hi there,
Do you know a sql command which I can write to obtain the last date that I
updated a table
On Tue, 5 Aug 2003 11:41:21 -0300
Fabio Bernardo <[EMAIL PROTECTED]> wrote:
> Hi there,
> Do you know a sql command which I can write to obtain the last date that I
> updated a table
>
SHOW TABLE STATUS LIKE 'yourtable';
fabrizio
--
MySQL General Mailing
Or load the date into a column date_str and then convert and copy the
date into a column date AFTER loading.
Cheers
/rudy
ps: I already posted a function of how to convert this date format into
a MySQL date format somewhere on this list (prev month I think)
-Original Message-
From: Jay
[snip]
How do you convert a date dd/mm/ from a .txt file
into mysql date
format when using LOAD DATA INFILE ?
[/snip]
LOAD DATA INFILE cannot do the conversion "on-the-fly". You could use a
scripting language (sed, awk,etc.) to read and convert the dates.
HTH!
--
MySQL General Ma
How do you convert a date dd/mm/ from a .txt file
into mysql date
format when using LOAD DATA INFILE ?
__
Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software
http://sitebuilder.yahoo.com
--
MySQL General Mailing List
For list
Mike,
Sure, try this:
UPDATE table SET days = TO_DAYS(exp_dte) - TO_DAYS(NOW());"
As a side note, I recommend you make this calculation in whatever
application this DB supports. Otherwise you will continue to need
running a script to update the dates.
Regards,
A$
On Saturday, August 2, 2003,
then calculate the number of
days to expiry in a query like this:
select (to_days(expdate) - to_days(curdate()) as days_to_expire from
xxx...; If you get a negative answer then the record has already past
it's expiry date.
If I've misunderstood then sorry, please try again.
Regards,
Andy.
Mik
Hello,
I need to update one of our mysql tables, which has about 60,000 entires and
correct the amount of days remain on each data record. An example of one of the
data entires is:
memiddaysregdate expdate
--
625290 | 5 | 2003-07-15 | 2003-08-
"C.F. Scheidecker Antunes" <[EMAIL PROTECTED]> wrote:
>
> I wonder if is there any way to select from a table all the records
> which has a Date Field that is at least five minutes old?
>
> In other words, I have a table with a date field and I need to select
&
801 - 900 of 1631 matches
Mail list logo
