[NaS]

You can do

Код:

SELECT CONVERT(varchar, REGDATE, 1) FROM ... WHERE ...

where varchar is the target datatype (string), REGDATE is the date you want to convert (the column from your table) and 1 is the format.

https://www.mssqltips.com/sqlservert...ng-sql-server/

There's a table with all the available format IDs, so if you want (for example) MM/DD/YY you can choose format 10.

The result will be one string (the date) which you can get from the cache like any other string (cache_get_value_string or similar).