You’re offline. This is a read only version of the page.
340
I am querying GL20000 - Open Financial Transactions Table.
One column I want to include is 'TRXDATE' which is a datetime type. The values stored are in the 'YYYY-MM-DD HH:MM:SS' format.
If my select statement is:
Select OPENYEAR, JRNENTRY, TRXDATE from GL20000, as an example,
What syntax should I use with the column name so that the return for TRXDATE is formatted as 'mm/dd/yyyy'?
In the table, if my return includes 500 transaction records, every date in the current open year may have been used.
*This post is locked for comments
Select OPENYEAR, JRNENTRY, TRXDATE, convert(varchar,TRXDATE, 101) from GL20000
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,253
Super User 2024 Season 2
#2
Martin Dráb
230,188
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (