[thelist] comparing a TIMESTAMP(6) entry in mysql to today's date

[rudy]

> Convert the format of the TimeStamp into a useful format
> using the DATE_FORMAT() function:
>
> http://www.mysql.com/doc/en/Date_and_time_functions.html#IDX1293

heh, funny you should mention that page, i had occasion to point somebody
to the exact same place just yesterday

but what's worse, the other day i told somebody that you could use

  CONVERT(CHAR(10),yourtimestamp,120)

in sql/server, when in reality you can do no such thing

<tip type="sql">
timestamps in mysql are standard sql timestamps
timestamps in sql/server have nothing to do with dates or times
</tip>

rudy