PxPlus User Forum

Main Board => Discussions => ODBC => Topic started by: mm_coder on February 27, 2023, 07:52:24 PM

Title: DATE field query
Post by: mm_coder on February 27, 2023, 07:52:24 PM

Using a select against a table column in DATE FORMAT.
SO_SalesOrderHeader.OrderDate

returns this 9/30/2020 12:00:00 AM
Any way to format the return value as?  9/30/2020
I have the ODBC manual, but can't figure it out.
Thanks

Title: Re: DATE field query
Post by: Devon Austen on February 28, 2023, 08:26:34 AM

You can use a Scalar functions (https://manual.pvxplus.com/?odbc/using_odbc_driver/scalar_functions.htm) to modify what is returned by the select:

SELECT LEFT(SO_SalesOrderHeader.OrderDate, POSITION(" " IN SO_SalesOrderHeader.OrderDate) - 1) From myTable