Visolve DB Team wrote:
hi
MySQL automatically converts a date or time type value to a
number (numeric context) & viceversa.
When the server starts, it attempts to determine the time zone of the
host machine and uses it to set the *system_time_zone* system variable.
The value does not chang
hi
MySQL automatically converts a date or time type value to a number (numeric
context) & viceversa.
When the server starts, it attempts to determine the time zone of the host
machine and uses it to set the system_time_zone system variable. The value does
not change thereafter.
The global time
Hello.
I was able to make a query which retrieves dates where the TA is
available only for specific TA. To list all TA and periods of time
where they're available I wrote a stored procedure which works in
MySQL 5.
Here is the definition and test data in my tbl_notavailable
(I've c
CF,
>tbl_NotAvailable {
> TAid - int(11)
> StartDate - DateTime
> EndDate - DataTime
>}
>Question one:
>Now, how can I return a calendar of the dates where the TA is AVAILABLE,
>that is the oposite of what is recorded?
You may be better off with an explicit calandar table containing slot
C.F. Scheidecker Antunes wrote:
Question one:
Now, how can I return a calendar of the dates where the TA is AVAILABLE,
that is the oposite of what is recorded?
I want a list of all the available days and times by substracting the
non available times recorded in the table.
I guess I would need t
The default timestamp display format changed between mysql 4.0 and 4.1
The easy fix is to add + 0 to all timestamp fields in selects. Like
this: select my_ts + 0 from t;
You should always read the upgrade notes in the manual. This is very well
documented:
http://dev.mysql.com/doc/mysql/en/upgradin
Brian Menke wrote:
Hi everyone, I've always had a challenge working with dates. I'm
building an app that needs to query a range of dates. I'm using ASP
(for the first time, I usually write in Java). Anyway my date column
uses the -00-00 format, which I think is the default format? Is
it?
Th
select to_days('2003-11-10') - to_days('2003-11-19')
- Original Message -
From: "Fabio Bernardo" <[EMAIL PROTECTED]>
To: "Mysql (E-mail)" <[EMAIL PROTECTED]>
Sent: Friday, September 19, 2003 4:13 PM
Subject: dates difference
I´d like to write a mysql statemant which takes two dates:
f
Joseph Bueno wrote:
.
.
.
rt3=# select age(now(),'2003-08-26'::timestamp);
age
6 days 10:14:43.421275
+++
Thanks,
and
select age('2003-08-26',resolved)
where 'resolved' is a 'timestamp'.
--
MySQL General Mailing List
For list archi
Mixo Shiburi wrote:
I am in the process of porting some python scripts to Mysql.
Currently, the scripts I have queries a Pg database for entries (made)
between certain dates.
The python script snippet of the query
mainQuery = """
select distinct
id,queue,own
2002-09-29 = 1973
I suppose dte>1973.
Johnny Withers wrote:
>I'm a bit confused here.. dates are not my strong point..
>I have a table with a date column in it (DATE datatype)
>
>a few values:
>mysql> select dte from images\G
>*** 1. row ***
>dte:
Short answer YES you have to have them
why because 2002-08-29 = 1965
-Original Message-
From: Johnny Withers [mailto:[EMAIL PROTECTED]]
Sent: Thursday, August 29, 2002 1:30 PM
To: [EMAIL PROTECTED]
Subject: DATES and WHERE
I'm a bit confused here.. dates are not my strong point..
I
* BUNTER MATTHEW
> I'm putting together a table that has dates of reign for a monarch.
>
> What I eventually want to do is to be able to ask the question :
>
> Who reigned during 1585? And get an answer of : King Joe
>
> This info will be outputted in a php form on a web page.
>
> So if the da
--- Reçu de VITEUR.BUNTERMA 04 72 96 57 77 29/05/02 17.27
2nd attempt.
Date: Wed, 29 May 2002 17:17:25 +0200
Subject: Re: Dates in a table
Your message cannot be posted because it appears to be
rc,
> off topic topic of mysql databaseperl
>
> i need to know how to build a linux timestamp from a date given to me in
> the following format 01-18-99 (m-d-y) i am using mysql to store this as an
> int(11).
>
> i know php has a mktime function, does anyone know if perl has something
> simil
Thanks, Paul. ;)
~rob
> -Original Message-
> From: Paul DuBois [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, January 09, 2002 8:22 PM
> To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
> Subject: Re: DATES & Optimization
>
>
> At 9:02 -0600 1/9/02, Robert L. Yelvin
At 20:22 -0600 1/9/02, Paul DuBois wrote:
>At 9:02 -0600 1/9/02, Robert L. Yelvington wrote:
>>Two quick qux for the gurus on the list!
>>
>>1. If I needed to do date calculations based upon a TIME STAMP field, what's
>>the most efficient way to accomplish this with respect to data types (field
>>
At 9:02 -0600 1/9/02, Robert L. Yelvington wrote:
>Two quick qux for the gurus on the list!
>
>1. If I needed to do date calculations based upon a TIME STAMP field, what's
>the most efficient way to accomplish this with respect to data types (field
>types...I already understand how to use the DATE
Date |Wed, 22 Aug 2001 10:49:47 -0700
>From |"Jason Brunk" <[EMAIL PROTECTED]>
Hello!
JB> i have noticed something, i have ported some asp, and visual basic applications
from MSSql to MySql, and i have noticed something with the dates, i have to change my
entire date format. Does anyone know
if you don't want the user to input trash, don't give him the opportunity.
on your form, put three two character input fields. label the fields month,
day and year, or what ever is the most common order that your user will
input a date. put '-' or whatever, between the fields - just to make th
karel pitra wrote:
>
> hi,
>
> first - using php wouldn't it be much easier to use an integer to
> store datetime in the database? - i think it's faster and it allows you to
> manipulate the date much more easily.
>
> you could just tokenize the date string (using space,'/' and '-' or any ohter
hi,
first - using php wouldn't it be much easier to use an integer to
store datetime in the database? - i think it's faster and it allows you to
manipulate the date much more easily.
you could just tokenize the date string (using space,'/' and '-' or any ohter
characters as the separators) - yo
22 matches
Mail list logo
