Skip to Content
0
Former Member
Feb 26, 2009 at 09:58 AM

conversion routines

34 Views

Hi.

I am made a view. I combined 4 system tables and got relational datas. But in one field I have to convert the value. I don't know how to do.

the field is date_1 of crmd_order_index table. System holds the date like 20081231220000, because of the time difference from England. but the real date sould be seen as 01.01.2009 in the view field.

This is not a code. This view will be used for a searh help in a table.

How can I convert this date field?

Thank you for your help.