Re: builtin func to extract date from datetime field

Norbert ,

Not sure if i understand your question

i supose when using the OO native Dbase >> GETDATE(`datetime-field`)

working with the resulset:

'cdate(oresultset.getstring(2)) makes a "date from a datetime value in 
de resultset
  cDateToISO makes a  "longvalue " needed in a  datecontrol in a  dialog
     oDialogControl.getControl("DateVan").Date = 
cdateToISO(cdate(oresultset.getstring(2)))

Hope it helps fernand
> Hello everybody!
>
> last evening I was trying to solve a tiny problem in base but didn't
> succeed !! Could it be that there is no built-in function to extract the
> date part of a datetime field??
>
> I have to set up a query in OO-base like this one. In "mysql dialect" it
> would be
>
> SELECT DATE(`datetime-field`) AS `workdate`, SUM(`field-2`),
> SUM(`field-3`), ....  FROM `Another-Query`
> WHERE ....
> GROUP BY `workdate`
> ORDER BY `workdate` DESC
>
> Couldn't find a proper way. Or am I just blind ??
>
> Norbert
> --
> -----------------------------------------------------------------
> To unsubscribe send email to [email protected]
> For additional commands send email to [email protected]
> with Subject: help

--
-----------------------------------------------------------------
To unsubscribe send email to [email protected]
For additional commands send email to [email protected]
with Subject: help