x Want to participate? Join the group to interact

Sage X3

Welcome to the Sage X3 Support Group on Community Hub! Available 24/7, the Forums are a great place to ask and answer product questions, as well as share tips and tricks with Sage peers, partners, and pros from around the globe.

General Discussion Format SYSDATETIME() in SQL Query

State Suggested Answer
Replies 3 replies
Answers 2 answers
Subscribers 135 subscribers
Views 1311 views
Users 0 members are here

Browse Forums

238

topics

29

replies

General Discussion

5k

topics

13k

replies

Sage Data & Analytics

56

topics

95

replies

Sage Enterprise Intelligence

212

topics

422

replies

Sage Intelligence Reporting

121

topics

322

replies

Format SYSDATETIME() in SQL Query

SUGGESTED

Posted By John Mitchell over 3 years ago

Anyone know how to format that so it displays MM/DD/YYYY HH/MM ? I've tried both data types D and A but just get MM/DD/YYYY.

Top Replies

Rafael over 3 years ago +1 suggested

This thread on Sage City can give you some options to attempt: www.sagecity.com/.../time-only-datatype

0 Rafael over 3 years ago

SUGGESTED

This thread on Sage City can give you some options to attempt: www.sagecity.com/.../time-only-datatype
Cancel
Vote Up +1 Vote Down

Sign in to reply

Verify Answer

Reject Answer

Cancel
0 John Mitchell over 3 years ago in reply to Rafael

Tried those guys. Guess this begs the question is there a list somewhere for built in SQL Query functions? Just looking for the current date and time. Can be two fields, any format.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Rafael over 3 years ago in reply to John Mitchell

SUGGESTED

Attached are some examples, using Datatype "D" for Date and for time using the type "HS".
Cancel
Vote Up +1 Vote Down

Sign in to reply

Verify Answer

Reject Answer

Cancel