this could help
http://www.mysql.com/doc/en/Date_and_time_functions.html
V!nay
Chris W wrote:
> Andy Prasetya wrote:
>
> > Hello,
> >
> > I'm a newbie in MySQL. I have a table that contains column 'startdate
> > [date]' and 'enddate [date]'. Somehow, I have to execute SQL that
> > search an
Andy Prasetya wrote:
Hello,
I'm a newbie in MySQL. I have a table that contains column 'startdate
[date]' and 'enddate [date]'. Somehow, I have to execute SQL that
search any entry that corresponds to the current year and current
month, e.g.:
"SELECT * FROM mytable WHERE fieldx = '123' AND (s
Hello,
I'm a newbie in MySQL. I have a table that contains column 'startdate
[date]' and 'enddate [date]'. Somehow, I have to execute SQL that search
any entry that corresponds to the current year and current month, e.g.:
"SELECT * FROM mytable WHERE fieldx = '123' AND (startdate LIKE
'2004-01
Aravind,
MySQL stores all dates as -MM-DD, if you must use MM/DD/ then you
can store it as a string.
The best method would be to let MySQL store the date as -MM-DD and
use:
select date_format(mydate, '%m/%d/%Y');
That will return mydate as "MM/DD/".
=S.
On Tue, 26 Feb 2002
[EMAIL PROTECTED]
> Subject: Date Manipulation
>
>
> Hi,
> How can I insert a date in mm/dd/ format in MySQL?
> Meseems, it only supports -mm-dd format. As I'm a
> beginner to MySQL, could anyone help me out and make
>
S,
Tuesday, February 26, 2002, 11:11:47 AM, you wrote:
SA> Hi,
SA> How can I insert a date in mm/dd/ format in MySQL?
SA> Meseems, it only supports -mm-dd format. As I'm a
SA> beginner to MySQL, could anyone help me out and make
SA> me solve this problem?
You can do it by yourself using
Hi,
How can I insert a date in mm/dd/ format in MySQL?
Meseems, it only supports -mm-dd format. As I'm a
beginner to MySQL, could anyone help me out and make
me solve this problem?
Thank you.
Aravind
__
Do You Yahoo!?
Everything you'll ever
HI !
First of all , thnx a lot for the attention.
The EXACT query i need is .
assume IN and OUT as date colums in the format "-MM-DD HH:MM:SS "
I need my query to return:
"How many seconds are there between IN and OUT but outside the period 8:00
to 20:00"
For example :
IN ="2001-10-20 02:30:0
On Mon, 26 Nov 2001, Julio Faerman wrote:
> Is there anything like a "to_hours()" function ?
> I need my query to to calculate how much time there is between two time
> values
Julio,
ok, we are trying to help you, but please make our lives a little bit
easier and tell us exactly what you
Well, to do date calculations, use DATE_SUB() and DATE_ADD() functions.
To convert to some other functions, use DATE_FORMAT() function. For
templates that DATE_FORMAT() needs, please refer to documentation.
There're bunch of'em
--
sherzodR
On Mon, 26 Nov 2001, Thomas Spahni wrote:
>On Mon,
On Mon, 26 Nov 2001, Julio Faerman wrote:
> Is there anything like a "to_hours()" function ?
> I need my query to to calculate how much time there is between two time
> values
Julio,
have a look at the UNIX_TIMESTAMP(date) and FROM_UNIXTIME(unix_timestamp)
functions. These allow to conver
Is there anything like a "to_hours()" function ?
I need my query to to calculate how much time there is between two time
values
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://
Check out DATE_SUB() and DATE_ADD() functions. Those are the one to do
the trick.
sherzodR
On Mon, 26 Nov 2001, Julio Faerman wrote:
>Hi !
>I have a table with 2 coluns with time values , for example, colum START
>("2001-11-20 23:34:03" , for example) and STOP ("2001-11-21 08:34:03" , for
>e
Hi !
I have a table with 2 coluns with time values , for example, colum START
("2001-11-20 23:34:03" , for example) and STOP ("2001-11-21 08:34:03" , for
example).
Given a interval of time, say 8 AM to 8 PM, i need my query to return the
total time between START and STOP outside this period.
Is t
14 matches
Mail list logo
