On Fri, May 22, 2009 at 12:42 PM, John Meyer 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 acceptab
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 com
nt donné que les email peuvent facilement
être sujets à la 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
>
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 com
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
see
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;
+++-
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 wrot
- Original Message -
From: "Hans Bernard" <[EMAIL PROTECTED]>
To:
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
> 01-APR-2005 >> DD-M
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-
--
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,
]
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+ func
.cc> Fax to:
Subject: Re: Date/Time Difference
Calculations
06/11/2004 03:37
L PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Friday, June 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]
gt;
Sent: Friday, June 11, 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 i
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 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,
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)" <[EMA
Chris,
This is how I do it:
SELECT UNIX_TIMESTAMP(time_sign_out) -UNIX_TIMESTAMP(time_sign_in)/3600
AS hours
HTH!
Cory
On Wed, 2002-10-30 at 13:50, Raymer, Chris wrote:
> Having trouble getting the syntax to calculate the time difference given 2 dates
>like so:
>
> A.) 2002-01-02 21:33:0
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 ther
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
At 10:31 AM -0800 2/5/01, Daniel Kirk wrote:
>Does MySQL have any date/time functions -> can anyone give me a URL where I
>can find some documentation on it. I'm looking for SQLServer equivalents of
>DateAdd(), DateDiff(), Month(), Year() etc
The MySQL Reference Manual is a good source of inform
22 matches
Mail list logo
