PxPlus User Forum

Twitter Twitter Twitter

Author Topic: Dates Columns how convert to string  (Read 912 times)

eldonfsr

  • Silver Member
  • ***
  • Posts: 39
    • View Profile
Dates Columns how convert to string
« 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...