>>You are confusing a value returned by datetime() function with what is displayed
>
>Sergey,
>
>kindly explain.

DateTime is stored internally as Date + (seconds/86400.0) and is independent of any settings. SET commands come in effect when you try to display the value or convert it to a string.