Toggle navigation
PxPlus User Forum
PxPlus User Forum
»
Main Board
»
Discussions
»
ODBC
»
DATE field query
Likes
« previous
next »
Print
Pages: [
1
]
Author
Topic: DATE field query (Read 1540 times)
mm_coder
Member
Posts: 5
DATE field query
«
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
Logged
Devon Austen
Administrator
Diamond Member
Posts: 386
Don’t Panic
Re: DATE field query
«
Reply #1 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
Logged
Principal Software Engineer for PVX Plus Technologies LTD.
Print
Pages: [
1
]
« previous
next »
PxPlus User Forum
»
Main Board
»
Discussions
»
ODBC
»
DATE field query