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 not
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
manipulation, nous ne pouvons accepter aucune responsabilité
pour le contenu fourni.
Date: Fri, 22 May 2009 07:14:58 -0600
From: john.l.me...@gmail.com
To: janek.bogu...@studylink.com
CC: mysql@lists.mysql.com
Subject: Re: Date Time
Janek Bogucki wrote:
Hi John,
http://dev.mysql.com/doc
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 not an
mysql select sysdate() from DUAL;
+-+
| sysdate() |
+-+
| 2009-05-21 17:37:13 |
+-+
i would get the proprt format is
i could CONVERT_TZ to work
can you get CONVERT_TZ to work ?
Martin Gainty
Hello.
You said that you had created a view, but you continued using Tab_A
instead of Tab_A_View in your next queries. Did you want to use view
Tab_A_View? On my MySQL 5.0.9 all queries works both with view and
original table. See:
mysql desc Tab_A;
On Wed, Apr 06, 2005 at 12:06:37PM +0200, Hans Bernard wrote:
i need to have the time in this output. in MySQL database
phpmyadmin always puts -00-00
i need it to be like this
01-APR-2005 DD-MMM-
Use date_format(, %d-%b-%Y %H:%m) in your SELECT?
bye,
-christian-
--
MySQL
- Original Message -
From: Hans Bernard [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Sent: Wednesday, April 06, 2005 6:06 AM
Subject: DATE TIME
Hello,
i need to have the time in this output. in MySQL database
phpmyadmin always puts -00-00
i need it to be like this
thanks for the hints date_format() solved my problem my select query in php is
now
the following:
$query = SELECT id, calltt, date_format(calldate, '%d-%b-%Y') AS calldate2,
date_format(calltime, '%H:%i') AS calltime2,area, problem, solution, assignto,
status FROM ticketing ;
hans
Rhino
Your tables aren't setup very well. You should google for
normalization and 'boyce codd normal form'
-Eric
On Sat, 16 Oct 2004 22:27:51 +0200, owca [EMAIL PROTECTED] wrote:
I'm trying get current week, starting from monday to sunday:
select UNIX_TIMESTAMP(day), g15, g16, g17, g18, g19, g20,
You probably want SEC_TO_TIME:
http://dev.mysql.com/doc/mysql/en/Date_and_time_functions.html
SELECT a as start, b as end, SEC_TO_TIME(end - start) FROM table
Eamon Daly
- Original Message -
From: Dirk Bremer (NISC) [EMAIL
Here is an example using sec_to_time. Note that the results are inconsistent
and sometimes inaccurate. It seems that when the difference is less than one
minute, the result is correct, when it is over one minute, the result is
incorrect.
select ident,
transfer_start,
transfer_end,
Time Zone
636-922-9158 ext. 8652 fax 636-447-4471
[EMAIL PROTECTED]
www.nisc.cc
- Original Message -
From: Dirk Bremer (NISC) [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, June 11, 2004 14:29
Subject: Re: Date/Time Difference Calculations
Here is an example using sec_to_time. Note
, 2004 14:29
Subject: Re: Date/Time Difference Calculations
Here is an example using sec_to_time. Note that the results are
inconsistent
and sometimes inaccurate. It seems that when the difference is less than
one
minute, the result is correct, when it is over one minute, the result
11, 2004 14:50
Subject: Re: Date/Time Difference Calculations
select
sec_to_time(time_to_sec(transfer_end)-time_to_sec(transfer_start));
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
to:
Subject: Re: Date/Time Difference
Calculations
06/11/2004 03:37
PM
]
www.nisc.cc
- Original Message -
From: [EMAIL PROTECTED]
To: Dirk Bremer (NISC) [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Friday, June 11, 2004 14:54
Subject: Re: Date/Time Difference Calculations
I didn't see where these were 4.1+ function so I think it will work. I
refer you
Ch 7 of the manual contains a list of date functions that allows you to do
everything, short of boiling an egg.
- Original Message -
From: "Kevin Xin Lin" [EMAIL PROTECTED]
To: "mysql" [EMAIL PROTECTED]
Sent: Wednesday, April 18, 2001 22:10
Subject: Date,time,datetime type
Hi there,
Hi,
Your main problem will be in storage - datetime fields are only down to the
second, so you will have to store the times as integers, and then do your
own arithmetic on them.
If you stored the time as ('unix time' * 100) + hundreths, then you could
probably still do some arithmetic using the
20 matches
Mail list logo
