Eran Arigi Posted March 17, 2022 Share Posted March 17, 2022 Hi Is it possible to represent a datetime field in the following pattern: 2022-03-15T00:00:00Z In the master file I can define the field as USAGE=HYYMD-SZ However how can I specify the T between the date and time The datasource which is Odata Rest webservices requires this format (also sent without single quotes around the datatime value so I cant use Alphanumeric string in the Usage format) With Thanks Yours Eran Link to comment Share on other sites More sharing options...
Eran Arigi Posted March 17, 2022 Author Share Posted March 17, 2022 Hi I have found the solution in an old focalpoint post: http://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/4447000916 " but there is a WebFOCUS date-time output format that will display the date-time with the T (and Z if desired). HYYMDU will display the T, while HYYMDUSZ will display both T and Z. SET DTSTANDARD = STANDARD -* DEFINE FILE CAR XDATE/HYYMDUS WITH COUNTRY = DT(20100817 09:43:42); END -* TABLE FILE CAR PRINT XDATE WHERE RECORDLIMIT EQ 1 ; END " Yours Eran Link to comment Share on other sites More sharing options...
David Beagan Posted March 17, 2022 Share Posted March 17, 2022 You can add a Z: XDATE1/HYYMDUSZ WITH COUNTRY = DT(20100817 09:43:42); Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now