[TYPO3] exec_INSERTquery what can I use for the sql NOW()?
peter.russ at 4many.net
Tue Mar 21 11:34:51 CET 2006
Matthew Manderson schrieb:
> Any clues as to what I can use for the sql NOW() in my exec_INSERTquery?
> At the moment I have constructed it but this does not seem like the TYPO3
> way as I would need to define it every time. With such perfectly formed
> exec_INSERTquery maybe there is a better way?
> $now = time();
> $now = date('YmdHis',$now)
IMHO there is NO TYPO3 way to get sql-functions trough the TYPO3-DB
layer :-( as the query always adds slashes using the XXXXXquery.
Reason might be that some of this functions are DB specific. And there
should be added an additional layer to the TYPO3 DB-layer to the
ADO-layer to implement that ;-)
Only workaround: create the query by yourself and use sql_query. But
this might not be "DB-safe"
More information about the TYPO3-english