select * from table where date_format(timestamp, '%y%m%d') = '010801'
"Jeff Oien" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> 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
>
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
