Re: date problems

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



you can mimic the old behaviour like so:
select TS, 1*TS as OldStyle;
(TS being your timestamp filed)

TS | 	OldStyle
2007-09-03 15:03:02 | 	20070903150302


rDubya wrote:
> 
> WOW!!  Thanks for all the help guys!!  And Instruct ICC.. you're
> solution for pulling the events did work.. but..  it turns out that
> the solution was actually much simpler than I thought:
> 
> The old mysql database (once again, not sure what version) stored the
> date as YYYYMMDDHHMMSS.  The new database stores the date as
> YYYY-MM-DD HH:MM:SS.  All I had to do was adjust my code to pull only
> the values and none of the delimeters (ie. "-", " ", and ":").
> DUH!!!!!!!
> 
> But once again, thanks you guys for all the help!!!!
> 
> 
> rDubya
> 
> 
> On 9/7/07, Instruct ICC <instructicc@xxxxxxxxxxx> wrote:
>> >From: "Instruct ICC" <instructicc@xxxxxxxxxxx>
>> >And while not trusting your indexing, rewrite short_date as:
>> My short_date rewrite was also wrong.  So it looks like you will have to
>> learn those offsets for this function if you do it on the PHP side.  But
>> you
>> could also do it on the MySQL side.
>>
>> _________________________________________________________________
>> Get a FREE small business Web site and more from Microsoft(r) Office
>> Live!
>> http://clk.atdmt.com/MRT/go/aub0930003811mrt/direct/01/
>>
>> --
>> PHP Database Mailing List (http://www.php.net/)
>> To unsubscribe, visit: http://www.php.net/unsub.php
>>
>>
> 
> -- 
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
> 
> 
> 

-- 
View this message in context: http://www.nabble.com/date-problems-tf4393599.html#a12634947
Sent from the Php - Database mailing list archive at Nabble.com.

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux