Hi Hank, all!
Hank wrote:
On Fri, Oct 1, 2010 at 2:34 PM, Joerg Bruehe joerg.bru...@oracle.com wrote:
Hi!
Hank wrote:
On Wed, Sep 29, 2010 at 8:33 AM, Patrice Olivier-Wilson
b...@biz-comm.com wrote:
On 9/28/10 8:33 PM, Chris W wrote:
SELECT *
FROM announcements
WHERE
I would argue that it's not a logical error. Typically, in my
experience when something expires, the date of expiry is inclusive,
and any date after expiry is not. Take any discount, coupon, or
promotion -- if it expires on December 31, it's still available on
that day. If an article expires
On 9/28/10 8:33 PM, Chris W wrote:
SELECT *
FROM announcements
WHERE announcements_expiredate CURDATE()
AND announcements_postdate = CURDATE()
ORDER BY announcements_expiredate ASC
Thank you!
--
Patrice Olivier-Wilson
http://biz-comm.com
--
MySQL General Mailing List
For list archives:
On Wed, Sep 29, 2010 at 8:33 AM, Patrice Olivier-Wilson
b...@biz-comm.com wrote:
On 9/28/10 8:33 PM, Chris W wrote:
SELECT *
FROM announcements
WHERE announcements_expiredate CURDATE()
AND announcements_postdate = CURDATE()
ORDER BY announcements_expiredate ASC
Or how about something
Hi... beginner here. Working on a php page and using this
$query_announcements = SELECT * FROM announcements WHERE
announcements.announcements_expiredate CURDATE() ORDER BY
announcements_expiredate ASC ;
Client now wants the announcement NOT to show until a specific date.
I have
NOT to show until a specific date.
I have an announcements_postdate in the table. Just not sure what the
WHERE should be to not show until that date.
Thanks much,
Figured it out
SELECT *
FROM announcements
WHERE announcements.announcements_expiredate CURDATE
this.
SELECT *
FROM announcements
WHERE announcements_expiredate CURDATE()
AND announcements_postdate = CURDATE()
ORDER BY announcements_expiredate ASC
Otherwise they won't show till after the postdate. I assume you want to
display them on the post date and not the next day? This of course
assumes your
, Weydson Lima weys...@gmail.com wrote:
I was referring to the function:
http://dev.mysql.com/doc/refman/5.1/en/date-and-time-functions.html#function_date-format
---
Weydson Lima
weys...@gmail.com
On Thu, May 6, 2010 at 1:58 PM, Martin Gainty mgai...@hotmail.com wrote:
http
...@gmail.com wrote:
I was referring to the function:
http://dev.mysql.com/doc/refman/5.1/en/date-and-time-functions.html#function_date-format
---
Weydson Lima
weys...@gmail.com
On Thu, May 6, 2010 at 1:58 PM, Martin Gainty mgai...@hotmail.com wrote:
http
You build pretty much any format you desire out of those speifiers. ie:
select date_format(now(),'%m/%c/%Y');
- md
On Thu, May 6, 2010 at 5:00 PM, Weydson Lima weys...@gmail.com wrote:
I was referring to the function:
http://dev.mysql.com/doc/refman/5.1/en/date-and-time-functions.html
Hi,
Is there any way to format all dates generated by a MySQL query as US
format? What I want to do is having a generic way to use the DATE_FORMAT
function on all my date fields, instead of having to enter them manually.
Thank you
---
Weydson Lima
weys...@gmail.com
http
I was referring to the function:
http://dev.mysql.com/doc/refman/5.1/en/date-and-time-functions.html#function_date-format
---
Weydson Lima
weys...@gmail.com
On Thu, May 6, 2010 at 1:58 PM, Martin Gainty mgai...@hotmail.com wrote:
http://lists.mysql.com/commits/60834
date_format system
-
From: Gavin Towey [mailto:gto...@ffn.com]
Sent: Friday, March 05, 2010 4:15 PM
To: Tompkins Neil; prabhat kumar
Cc: [MySQL]
Subject: RE: Displaying date/time
That's probably something best done in your presentation (app) layer.
If you must do this in mysql, then you'll probably want
: Displaying date/time
That's probably something best done in your presentation (app) layer.
If you must do this in mysql, then you'll probably want to write a stored
function.
-Original Message-
From: Tompkins Neil [mailto:neil.tompk...@googlemail.com]
Sent: Friday, March 05, 2010 10:27 AM
' );
END
Maybe this will help.
Thanks,
Randall Price
Senior Programmer Analyst
Virginia Tech
-Original Message-
From: Gavin Towey [mailto:gto...@ffn.com]
Sent: Friday, March 05, 2010 4:15 PM
To: Tompkins Neil; prabhat kumar
Cc: [MySQL]
Subject: RE: Displaying date/time
That's
Hi
I have a number of rows which have Date and Time data in. I want to display
in the following formats based on the systems current time
e.g under 1 hour 24min ago
e.g under 1 day 16h 29min ago
e.g over 1 day 1d 2h 29min ago
e.g over 1 week 1w 4d 2h 29min ago
How would this best be achieve
);
Thanks,
On Fri, Mar 5, 2010 at 8:19 PM, Tompkins Neil
neil.tompk...@googlemail.comwrote:
Hi
I have a number of rows which have Date and Time data in. I want to
display
in the following formats based on the systems current time
e.g under 1 hour 24min ago
e.g under 1 day 16h 29min ago
Hi
That is kind of what I'm looking for. However I'd like to be able to
display the difference between date 1 and date 2 like
1d 2h 29min ago
Thanks
Neil
On Fri, Mar 5, 2010 at 3:32 PM, prabhat kumar aim.prab...@gmail.com wrote:
Might be this will help you:
there is a table called message
Cc: [MySQL]
Subject: Re: Displaying date/time
Hi
That is kind of what I'm looking for. However I'd like to be able to
display the difference between date 1 and date 2 like
1d 2h 29min ago
Thanks
Neil
On Fri, Mar 5, 2010 at 3:32 PM, prabhat kumar aim.prab...@gmail.com wrote:
Might
Hi all
I hope someone can help me out here as I am still new with MySQL.
I am trying to determine when last a MySQL database was shut down and
when last the tables were analyzed.
Can someone please assist in this and let me know if this is
possible.
In the last episode (Oct 26), machiel.richards said:
I hope someone can help me out here as I am still new with MySQL.
I am trying to determine when last a MySQL database was shut down and
when last the tables were analyzed.
The server logs startups and shutdowns in the mysqld error
after 30 day's ,
Then i have to show the message contact admin ,
If they tried with in 30 days , then i have to show message , like courier
SENT / PEND / FAILED ,
Can u please tell the query ,
If the *r_date *(recive date) greater then of 30 days , they i have to
show message like
with in 30 days , then i have to show message , like courier
SENT / PEND / FAILED ,
Can u please tell the query ,
If the *r_date *(recive date) greater then of 30 days , they i have to show
message like contact admin
Please tell the query ,
Thanks
I'm pulling in a date with the following format
9/14/2009 2:12:48 PM
And using this mask to convert it using the str_to_date() function:
%e %m %Y %r
but it keeps giving me an error. Do I have the right mask?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
In the last episode (Sep 14), John Meyer said:
I'm pulling in a date with the following format
9/14/2009 2:12:48 PM
And using this mask to convert it using the str_to_date() function:
%e %m %Y %r
but it keeps giving me an error. Do I have the right mask?
Nope. Assuming your input string
Dan Nelson wrote:
In the last episode (Sep 14), John Meyer said:
I'm pulling in a date with the following format
9/14/2009 2:12:48 PM
And using this mask to convert it using the str_to_date() function:
%e %m %Y %r
but it keeps giving me an error. Do I have the right mask?
Nope
I am using mysql Server version: 5.1.31 MySQL Community Server (GPL) on a
MAC 10.5 host. I am having some strange date translation issues when I
insert dates into my tables.
What I do is run perl¹s Spreadsheet::ParseExcel module with Time::JulianDay
to reformat excel dates to insert properly
mysql desc maintenance;
++--+--+-++---+
| Field | Type | Null | Key | Default| Extra |
++--+--+-++---+
| indate | date | YES | | NULL
;
++--+--+-++---+
| Field | Type | Null | Key | Default | Extra |
++--+--+-++---+
| indate | date | YES | | NULL
`;
+-+-
+
| Table | Create Table
|
+-+-
+
| maintenance | CREATE TABLE `maintenance` (
`indate` date DEFAULT NULL,
`contract` char(25) NOT NULL
,
`password` varchar(10) NULL,
`country` varchar(45) NULL,
`zipcode` varchar(5) NULL,
`city` varchar(35) NULL,
`hstate` varchar(45) NULL,
`exclusive` varchar(7) NULL,
`eventtime` time NULL DEFAULT current_time(),
`eventdate` date NULL DEFAULT
,
`exclusive` varchar(7) NULL,
`eventtime` time NULL DEFAULT current_time(),
`eventdate` date NULL DEFAULT current_date(),
`eventdura` varchar(35) NULL,
`daysevent` varchar(10) NULL,
`crowd` varchar(25) NULL,
`venue` varchar(50) NULL,
`activitytype
-Original Message-
From: Jason Todd Slack-Moehrle [mailto:mailingli...@mailnewsrss.com]
Sent: Friday, June 26, 2009 1:10 PM
To: mysql@lists.mysql.com
Subject: Default Date and Time
Hi All,
I want to create a table that defaults to current_date and current_time.
[JS] Would a timestamp
Hi all !
Is there any method to find the CREATION DATE of an EXISTING database and
tables in MySQL 5.0 or newer versions?
Thanks,
Uma
Is there any method to find the CREATION DATE of an EXISTING database and
tables in MySQL 5.0 or newer versions?
information_schema.tables.create_time for tables.
PB
Uma Bhat wrote:
Hi all !
Is there any method to find the CREATION DATE of an EXISTING database and
tables in MySQL 5.0
Thanks for the response, Peter.
Yeah, I am aware of this to find it for the tables. However I require to
find the creation time of a database..
Thanks,
Uma
On 6/3/09, Peter Brawley peter.braw...@earthlink.net wrote:
Is there any method to find the CREATION DATE of an EXISTING
Hi John,
http://dev.mysql.com/doc/refman/5.1/en/date-and-time-types.html includes
some information about acceptable literal forms for dates and times.
'Thu May 21 03:15:28 + 2009' is not an acceptable literal form but
this is how to parse it APART from the time zone component. I could
Janek Bogucki wrote:
Hi John,
http://dev.mysql.com/doc/refman/5.1/en/date-and-time-types.html includes
some information about acceptable literal forms for dates and times.
'Thu May 21 03:15:28 + 2009' is not an acceptable literal form but
this is how to parse it APART from the time zone
|
+-+
| 2009-05-21 03:15:28 |
+-+
most of us have contacts in europe who dont use EDT,CDT,MDT or PDT so
i *was hoping* to get confirmation on CONVERT_TZ(date,from_tz,to_tz) works?
Thanks,
Martin Gainty
__
Verzicht und
Janek Bogucki wrote:
Hi John,
http://dev.mysql.com/doc/refman/5.1/en/date-and-time-types.html includes
some information about acceptable literal forms for dates and times.
'Thu May 21 03:15:28 + 2009' is not an acceptable literal form but
this is how to parse it APART from the time zone
On Fri, May 22, 2009 at 12:42 PM, John Meyer john.l.me...@gmail.com wrote:
Janek Bogucki wrote:
Hi John,
http://dev.mysql.com/doc/refman/5.1/en/date-and-time-types.html includes
some information about acceptable literal forms for dates and times.
'Thu May 21 03:15:28 + 2009
Is Thu May 21 03:15:28 + 2009 a valid date/time string?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
facilement
être sujets à la manipulation, nous ne pouvons accepter aucune responsabilité
pour le contenu fourni.
Date: Thu, 21 May 2009 15:19:16 -0600
From: john.l.me...@gmail.com
To: mysql@lists.mysql.com
Subject: Date Time
Is Thu May 21 03:15:28 + 2009 a valid date/time string
Hi,
I have a table with a column like:
date date default null,
If I enter an empty string in it, the default null value is added (as it
should).
But if I enter an invalid date by mistake, the date -00-00 date date is
entered instead of the default null, and this is not good.
Can I do
Hi Octavian,
One approach is to use a trigger,
mysql set sql_mode = '';
mysql create table temp_date(d date default null);
mysql create trigger temp_date_bi before insert on temp_date for each row set
new.d = if(new.d = '-00-00', null, new.d);
mysql insert into temp_date(d) values('2009
Hi,
I have a table with a column like:
date date default null,
If I enter an empty string in it, the default null value is added (as it
should).
But if I enter an invalid date by mistake, the date -00-00 date date
is entered instead of the default null, and this is not good.
Can I
Agreed. And don't forget to listen to the warnings MySQL sends back,
e.g.:
mysql create table temp_date(d date default null);
Query OK, 0 rows affected (0.15 sec)
mysql insert into temp_date(d) values('2009-13-99');
Query OK, 1 row affected, 1 warning (0.00 sec)
mysql show warnings
At the risk of getting spanked for not finding this in the documentation,
I'm asking a simple question:
Can I tell when a table was created?
Regards,
Jerry Schwartz
The Infoshop by Global Information Incorporated
195 Farmington Ave.
Farmington, CT 06032
860.674.8796 / FAX:
At 10:28 AM -0400 5/5/09, Jerry Schwartz wrote:
At the risk of getting spanked for not finding this in the documentation,
I'm asking a simple question:
Can I tell when a table was created?
Try
show table status
or
select table_name,create_time from information_schema.tables
facilement
être sujets à la manipulation, nous ne pouvons accepter aucune responsabilité
pour le contenu fourni.
From: jschwa...@the-infoshop.com
To: mysql@lists.mysql.com
Subject: Creation date
Date: Tue, 5 May 2009 10:28:28 -0400
At the risk of getting spanked for not finding
I would have said to look at the creation date of the .frn file, but there
is also a field called create date in the show table status command and
the 2 dates often differ. Anyone know why they do?
On Tue, May 5, 2009 at 9:28 AM, Jerry Schwartz
jschwa...@the-infoshop.comwrote:
At the risk
The create date in show table status is metadata held in the table
itself wheras the create data on the .frm file is when that file was
created - i.e. if you copy the data files (without preserving
attributes) it will have a new creation date on the filesystem but the
metadata of the table
Thanks, I knew it had to be something simple. Now I can clean out my save
this in case you make a mistake tables.
-Original Message-
From: Steve Edberg [mailto:sbedb...@ucdavis.edu]
Sent: Tuesday, May 05, 2009 11:00 AM
To: Jerry Schwartz; mysql@lists.mysql.com
Subject: Re: Creation date
Hi,
I don't quite understand (or even know) what the proper way to compare a
DATETIME column to a given DATE value is. I've used various methods but I'd
like to know if there's a better way to compare these values.
Right now I have a query with this in the WHERE clause (customer.created_dt
-Original Message-
From: Johnny Withers [mailto:joh...@pixelated.net]
Sent: Wednesday, December 31, 2008 1:13 PM
To: MySQL General List
Subject: Compare DATETIME to DATE
Hi,
I don't quite understand (or even know) what the proper way to compare
a
DATETIME column to a given DATE value
Truncate the time part of the datetime field when doing the compare
AND DATE_FORMAT(customer.created_dt, '%Y-%m-%d 00:00:00') BETWEEN '2008-12-30'
AND '2008-12-30'
Should work. Probably not the most efficient. The other options would be to
use take end date + 1 day, minue 1 second. That's
well, our slow.log is pretty huge and say I just want the logs in the
last week. (tail -n XXX is not good enough)
I'm wondering there is a script (Perl or bash or others) can do this?
I'm not willing to reinvent the wheel. :)
Thanks.
--
Fayland Lam // http://www.fayland.org/
Foorum based on
Syslog-ng combined with logrotate
--Original Message--
From: Fayland Lam
To: mysql@lists.mysql.com
Subject: slow.log by date
Sent: Nov 30, 2008 18:22
well, our slow.log is pretty huge and say I just want the logs in the
last week. (tail -n XXX is not good enough)
I'm wondering
[EMAIL PROTECTED] wrote:
Syslog-ng combined with logrotate
well, logrotate is for the coming log. what can we do towards existing
ones. :)
Thanks.
--Original Message--
From: Fayland Lam
To: mysql@lists.mysql.com
Subject: slow.log by date
Sent: Nov 30, 2008 18:22
well, our
Write a perl script
Am sure there are some out there
Look at addons for awstats.
--Original Message--
From: Fayland Lam
To: [EMAIL PROTECTED]
Cc: mysql@lists.mysql.com
Subject: Re: slow.log by date
Sent: Nov 30, 2008 18:37
[EMAIL PROTECTED] wrote:
Syslog-ng combined with logrotate
Timestamp is the best bridge between java and mysql,I think.
On Sun, Oct 19, 2008 at 4:48 PM, Rama [EMAIL PROTECTED] wrote:
DATE TIME ZONE SENSITIVE
DATETIME NOT SENSITIVE TO TIME ZONE
TIMESTAMP TIMEZONE SENSITIVE
iam getting the above problem as date is timezone sensitive.i resolved
Default
Timezone : GMT+5:30
program trying to store
date : 2008-10-20 12:23:09-stored as
: 2008-10-20 12:23:09
program trying to retrieve
print
date : 2008-10-20 06:23:09--- 2008-10-20
12:23:09
(here
hi martin,Thanks,
But my problem is Why it is printing wrong date ( 2008-10-20 06:23:09 ) instead
of ( 2008-10-20 12:23:09 )
what is going wrong here?
On Tue, Oct 21, 2008 at 7:33 AM, Martin Gainty [EMAIL PROTECTED] wrote:
look at the MySQL doc to figure out whats going on
default MySQL
2008/10/19 Rama [EMAIL PROTECTED]
hi,
iam using java,hibernate,mysql
i am storing *19-10-2008 (*of type java.sql.Date) (TIMEZONE GMT) to
mysql
DATE field.
when i retrieve the same date from mysql to java it is being displayed as
*18-10-2008 18:30:00 GMT *
i could not able
i figured out the root cause of the problem.
1) Java TIME ZONE is GMT --- storing DATE (2008-10-19
which is in GMT )
2) storing the above date in GMT to mysql
3) MYSQL TIME ZONE IS GMT+05:30
4) as mysql time zone is GMT+05:30 it is viewing the date as (2008-10-19
The above argument applies to only MYSQL DATE field (timezone
sensitive)
where as in the case DATETIME Field it does not do any conversion gets
what we store (timezone insensitive)
in the case of TIMESTAMP Field it gets converted between UTC
and local timezone
SK wrote:
2008/10/19 Rama [EMAIL PROTECTED]
hi,
iam using java,hibernate,mysql
i am storing *19-10-2008 (*of type java.sql.Date) (TIMEZONE GMT) to
mysql
DATE field.
when i retrieve the same date from mysql to java it is being displayed as
*18-10-2008 18:30:00 GMT *
i could
DATE TIME ZONE SENSITIVE
DATETIME NOT SENSITIVE TO TIME ZONE
TIMESTAMP TIMEZONE SENSITIVE
iam getting the above problem as date is timezone sensitive.i resolved it
by changing the field type from date to string.
YOu can use any method to fill the DATE field of mysql .which method we
use
hi,
iam using java,hibernate,mysql
i am storing *19-10-2008 (*of type java.sql.Date) (TIMEZONE GMT) to mysql
DATE field.
when i retrieve the same date from mysql to java it is being displayed as
*18-10-2008 18:30:00 GMT *
i could not able to figure out what is going wrong . can any one
Ananda Kumar írta:
Hi All,
I think i worked on this and found the results.
I did the below.
1. Multiplied the week_of_the_year with 7 (7 days per week), to get the
total number of days from begning of the year.
2. used mysql function makedate
makedate(year,number of days from the start
to the last week of the previous year.
See these lines quoted from Linux man date:
~ man date | grep week
...
%g last two digits of year of ISO week number (see %G)
%G year of ISO week number (see %V); normally useful only with %V
%u day of week (1..7); 1
Sunday or Monday.
By both definitions, January 1 need not belong to week 1, it may belong to
the last week of the previous year.
See these lines quoted from Linux man date:
~ man date | grep week
...
%g last two digits of year of ISO week number (see %G)
%G year of ISO
HI All,
I have table which stores week_of_the_year and year.
For example
week_of_yearYEAR
32 2008
I want to convert this into the date. That is , i need to get the date of
first day of the week 32.
some thing like
03-AUG-2008.
Regards
anandkl
week_of_the_year and year.
For example
week_of_yearYEAR
32 2008
I want to convert this into the date. That is , i need to get the date of
first day of the week 32.
some thing like
03-AUG-2008.
Regards
anandkl
--
Help build our city at http://free
Hi All,
how to Get file modified time and date of file by using builtin function or
procedure in sql?
Thanks,
Siva
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
which file are u talking about.
regards
anandkl
On 7/24/08, Sivasakthi [EMAIL PROTECTED] wrote:
Hi All,
how to Get file modified time and date of file by using builtin function or
procedure in sql?
Thanks,
Siva
--
MySQL General Mailing List
For list archives: http
Ananda Kumar wrote:
which file are u talking about.
regards
anandkl
Ordinary temp file.. say example in C:\output.txt
Actually i have given that file as input to some procedure, based on
that modification time we have calculate some details.
--
MySQL General Mailing List
For list
you can do that using OS command, any specific reason u want to use stored
proc to get this information.
On 7/24/08, Sivasakthi [EMAIL PROTECTED] wrote:
Ananda Kumar wrote:
which file are u talking about.
regards
anandkl
Ordinary temp file.. say example in C:\output.txt
Actually i
Ananda Kumar wrote:
you can do that using OS command, any specific reason u want to use
stored proc to get this information.
OS Command? could you explain with examples? because, I have more # of
input files.. thats why iam going to procedure..
--
MySQL General Mailing List
For list
If windows u can use
dir file_name
Volume in drive C has no label.
Volume Serial Number is 9822-5D20
Directory of C:\
07/26/2005 02:26 AM 1,442 archival_s.pls
1 File(s) 1,442 bytes
0 Dir(s) 5,230,874,624 bytes free
in unix
ls -ltr
how to Get file modified time and date of file by using builtin
function or procedure in sql?
On Codd's rules, it oughtn't to be possible---it'd be a backdoor. If
there is a need to know the datetime of the last mod to a table, that
info ought to be in a column in a table.
PB
--
MySQL
Sivasakthi wrote:
Ananda Kumar wrote:
which file are u talking about.
regards
anandkl
Ordinary temp file.. say example in C:\output.txt
Actually i have given that file as input to some procedure, based on
that modification time we have calculate some details.
It sounds like you are
On Thu, Jul 24, 2008 at 1:17 AM, Sivasakthi [EMAIL PROTECTED] wrote:
Hi All,
how to Get file modified time and date of file by using builtin function or
procedure in sql?
In a related thread from earlier today you were advised that any
interaction with the filesystem should be done via
Hi Aaron, I'm not sure if what you want can be done with MySQL, but what you
can do is a little script in python, php, etc, that query your database for
the members that expire at a given date, and then email them. Then you tell
cron o similar to execute your script as often as you require. Hope
Or, you can use cron/at to schedule the task
Mauricio Tellez wrote:
Hi Aaron, I'm not sure if what you want can be done with MySQL, but what you
can do is a little script in python, php, etc, that query your database for
the members that expire at a given date, and then email them. Then you tell
database for
the members that expire at a given date, and then email them. Then you
tell
cron o similar to execute your script as often as you require. Hope it
helps
2008/7/4 Aaron Norlund [EMAIL PROTECTED]:
Hello all,
I have no experience with MySQL, but am reading through the available
Hello all,
I have no experience with MySQL, but am reading through the available texts.
However, I feel what I need to do is probably way into these, so perhaps
someone could give me a hand.
I have taken over administering a website with a user database made with MySQL.
It keeps track of
Hi,
I am looking for a query which can give all the dates of months. Inputs are
year and month.
--
Krishna Chandra Prajapati
David Perron schrieb:
Hello Users-
I think I have an interesting question with regards to applying a function
to date range, I think half of problem solving is explaining it to an
audience so please, bear with me.
There is a table Orders that has two DATE columns, StartDate and EndDate
David Perron schrieb:
Hi Sebastian-
Wanted to follow up on this. I figured out the problem. You actually
have to use the LEAST GREATEST operators when comparing multiple
values, this statement works perfectly.
LEAST(EndDays,Q2EndDays) - GREATEST(Q2StartDays,StartDays) as DaysInQ2,
Hello Users-
I think I have an interesting question with regards to applying a function
to date range, I think half of problem solving is explaining it to an
audience so please, bear with me.
There is a table Orders that has two DATE columns, StartDate and EndDate.
The range of dates can vary
)
Is it safe to assume that the expression calling the function DATE_SUB
is evaluated just once to a fixed date?
Yes, that's correct.
--
Baron Schwartz, Senior Consultant, Percona Inc.
Tel: +1 888 401 3401 ext 507
24/7 Emergency Line +1 888 401 3401 ext 911
Our Services: http://www.percona.com
to a fixed date?
Thanks
Jamie Madill
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hi,
table table1 int1 int auto_increament ,
date date not null default '-00-00'
1) insert into table1 (date) values('. . ')
// shows Incorrect date value: '. . ' for column date' at row 1
// '. . ' == space(4)+.+space(2)+.+space(2)
2) update
Hello mysql,
I have a PHP script that is running the following query:
SELECT `Messages`.`ID`,
`Messages`.`Sender`,
`Messages`.`Subject`,
DATE_FORMAT( `Messages`.`Date`, '%D %M %Y' ) AS Date,
LEFT(`Messages`.`Text`, 200 ) AS Preview,
`Messages`.`New`,
`Profiles`.`NickName`,
`Profiles`.`RealName
Hello mysql list,
As is very often the case, five minutes after I posted this, I found
the problem or solution, not sure it was the problem as I am not
convinced that mysql ought to get confused so easily. I changed
DATE_FORMAT( `Messages`.`Date`, '%D %M %Y' ) AS Date,
DATE_FORMAT( `Messages
I have a report that contains a WHERE statement to report on a date range in
Pentaho.
WHERE
InOut.MOVEMENTDATE = (CURRENT_DATE - 7)
I want to show on the report what the first date of this range is. Can
someone help me with this statement? So if the last seven days is January
24, 2008
I have a report that contains a WHERE statement to report on a date
range in
Pentaho.
WHERE
InOut.MOVEMENTDATE = (CURRENT_DATE - 7)
I want to show on the report what the first date of this range is. Can
someone help me with this statement? So if the last seven days is
January
24, 2008
, but on days (such as 1/3/2008 in the
above example) where there is no event, how could I get the date to
display?
The query I am using is:
SELECT
from_unixtime(`mainDate`,%m/%d/%Y),
Count(`ID`)
FROM
`main_data`
WHERE
`department` = '9'
GROUP BY
from_unixtime(`mainDate`,%m/%d/%Y
legolas schrieb:
Hi
Thank you for reading my post
Is there any scheduled date mysql 6 release?
don't know
I heard that it is based on falcon and can perform better...
based on in the wrong term, MyISAM will still be the default storage
engine, it just adds Falcon as a new storage engine
101 - 200 of 1564 matches
Mail list logo
