Hi Is it possible to represent a datetime field in the follo...

[Eran Arigi]

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

[Eran Arigi]

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

[David Beagan]

You can add a Z:

XDATE1/HYYMDUSZ WITH COUNTRY = DT(20100817 09:43:42);