Tech Tip: Using CAST does not alter the structure of source data

PRODUCT: 4D | VERSION: 13.2 | PLATFORM: Mac & Win

Published On: December 20, 2012

The CAST function is a temporary change - it does not alter the structure of the source data on the server; it simply alters the data recieved.

The following method converts the dateField to text using the CAST sql function:

Begin SQL
   select uuid_a, cast(dateField as text), number
   from customer
   where number = 542
End SQL

For more information on CAST, please see:
https://doc.4d.com/4Dv12.5/help/Title/en/page354.html
https://doc.4d.com/4Dv12.5/help/Command/en/page18321.html