> NEW.posting_date = 'now'
> ('now' is transformed in a timestamp, including the hour, minute and second)
>
> NEW.posting_date = 'today'
> ('today' is transformed in a date without the hour, minute and second)

Just to be pedantic - 'now' includes the fractional part of
the current date ( the time ) while 'today' does not. The
'transformations' happen when you look at the results or am
I still getting the internals wrong?

--
Lester Caine
-----------------------------
L.S.Caine Electronic Services