Re: Limit Select Field Characters?
| From: | Hugh Bothwell | Date: | Thu, 02 Aug 2001 02:22:03 +0000 |
| Subject: | Re: Limit Select Field Characters? | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-10982@lists.php.net to get a copy of this message | ||
select * from table where date_format(timestamp, '%y%m%d') = '010801'
"Jeff Oien" <jeff@webdesigns1.com> wrote in message
news:PGEBKOPJJHHICHGDKCCIAEEOCOAA.jeff@webdesigns1.com...
> I have a timestamp field that looks like this
> 0109011754
> but I only want to compare
> 010801
> when doing a SELECT. Is there a way I can do this? Thanks.
> Jeff Oien
>