select * from table where date_format(timestamp, '%y%m%d') = '010801'

"Jeff Oien" <[EMAIL PROTECTED]> wrote in message
> 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 (
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Reply via email to