Jump to content
The ibi Community has moved to a new platform: Please Sign In and choose Forgot Password to continue

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


Eran Arigi

Recommended Posts

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

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

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 account

Sign in

Already have an account? Sign in here.

Sign In Now
×
  • Create New...