[dev] [cvs] commit: turba/lib Driver.php turba/lib/Driver sql.php

Michael Rubinsky mike at theupstairsroom.com
Sun Oct 28 14:23:20 UTC 2007


Quoting Jan Schneider <jan at horde.org>:

> Zitat von Michael Rubinsky <mike at theupstairsroom.com>:
>
>> mrubinsk    2007-10-28 10:23:35 EDT
>>
>>   Modified files:
>>     lib                  Driver.php
>>     lib/Driver           sql.php
>>   Log:
>>   - Pass the date range to _getTimeObjectTurbaList() method
>>   - Only get the bday field if we are searching for a bday
>>
>>   Now all I need to do is figure out how to do that date compare
>> against a varchar field in the database...
>
> The question is whether this should be varchar at all. I used a date
> field for birthdays since ages. OTOH, using a varchar with iso dates
> is more portable and allows string comparisons.

I assumed it was done for the latter reason...would a: 'WHERE  
date_field BETWEEN '1970-01-01' AND '1970-01-31' be portable across  
different sql servers?  I'm pretty familiar with MySQL, but wasn't  
sure if this would work on others?


Thanks,
mike

--
The Horde Project (www.horde.org)
mrubinsk at horde.org

"Time just hates me. That's why it made me an adult." - Josh Joplin
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 189 bytes
Desc: PGP Digital Signature
Url : http://lists.horde.org/archives/dev/attachments/20071028/15ceaa9b/attachment-0002.bin 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-keys
Size: 2013 bytes
Desc: PGP Public Key
Url : http://lists.horde.org/archives/dev/attachments/20071028/15ceaa9b/attachment-0003.bin 


More information about the dev mailing list