Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

Does VORTEX convert dates passed in strings to the database format?

April 26, 2017convert database dates format strings Vortex

0

Posted

Does VORTEX convert dates passed in strings to the database format?

1 Answer

0

Posted

No, VORTEX does not modify any data passed to VORTEXcli. Dates are a problem for DBMS applications because every DBMS has a different date string format. If you pass date/time information in as a string, the application is reponsible for making sure the format is correct. If you use our TDT_DATETIME format, then you will always be ok. Use our conversion routines to convert your date/time string into our internal datetime format.