Tuesday, 10 September 2013

how to create a calculated column in mysql which calculate date from timestamp column having varchar type

how to create a calculated column in mysql which calculate date from
timestamp column having varchar type

I m stuck in a big problem. I want to create a calculated column in an
existing table having a column name LS_TimeStamp of Varchar(20) type which
store both date and time in format (0000-00-00 . 00:00:00) and i want a
calculated column which extract only date from that column and stores in
'Date' column which is also a Varchar(20) type.
Thanks in advance :)

No comments:

Post a Comment