Skip to Content
0
Former Member
Jul 31, 2008 at 01:25 PM

Split a DEC into date and time fields

1493 Views

I have a decimal datatype DEC length 15 which contains a date and time information for eg: 20,080,428,193,043

I need to convert this into two fields containing date and time separately.

Foe eg: here should be:

2008/04/28 and 19:30:43

How can I do this?

Thanks.