User Form : How transform timestamp date to readable date ?

Applications Forms
#1

Hello,

Overview :
I need to add some new featuring form to an existing application based on Mysql 5.X database.
I decided to use SC to perform the job :wink: as I have a short delay to achieve the implementation.

Issue :

I need to build a sample form with the user will modify an existing date.Otherwise, the date formating in the database is “timestamp” (like this :1391121505).

Could you please help me to find out a way to show to my user a normal date field instead of timestamp ?

I find a way (please see the attached screenshot) but when the user perform a save the field have some additional digit.

Thanks in advance for your support

Regards

Mehdi

TimeStamp2date.jpg

#2

Calculate your timestamp with php date

date("format",timestamp)

or directly from sql


to_char(timestamp,"format") as create_date
or it might work cast(timestamp as date) as create_date
#3

many thx, it works !!