Can I encrypt a datetime field or a number field and store it in database in datetime datatype column or number datatype column instead of varchar datatype column ?
Discussion posts and replies are publicly visible
Hi,
To Encrypt : todecimal(now())
Result : -6212.573
Decrypt : todatetime(todecimal(now()))
Result : 28/12/2017 11:14 CET
this may solve your problem