>Hi,
>
>SQL, remote view of MYSQL issue..
>
>What function should I use to get a DATE portion of a DATETIME field ?
>
>..Or, how do I compare those datetime fields with constants data, I mean:
>
>
>..WHERE table1.dttimefld >= ?? AND table1.dttimefld =< ??
>
>
>TIA
>
>Claudio
This works for SQL Server, don't know about MYSQL:
..WHERE table1.dttimefld >= '20040801' AND table1.dttimefld =< '20040901'