PxPlus User Forum
Main Board => Discussions => ODBC => Topic started by: eldonfsr on February 07, 2024, 10:51:11 AM
-
Hello friend just question how i can datecolumn from sql to put in sql not as date as string
i dis some but separete like this
DataModule1.ZQPo.SQL.Text:='select PO1_PurchaseOrderEntryHeader.* , {fm MONTH(PurchaseOrderDate)} as NewDate from PO1_PurchaseOrderEntryHeader ';
this generate a new comlun names newdate but i need hold column not juts month or day or year sepate
is sow some with scalar....
{fd DATETOSTR(PurchaseOrderDate)} as NewDate
could be possible...