Resolved How To Convert Datetime To Decimal Value And Decimal To Datetime

[Pramod Nair]

I am having a decimal field where decimal value of the selected date which is datetime is to be stored. How do i convert datetime value to decimal value and also decimal to datetime value.

 

[nborshukov]

define variable dt as datetime no-undo.
define variable dec-dt as decimal no-undo decimals 8.
define variable dt-1 as datetime no-undo.

   dt = now.
   dec-dt = integer(date(dt)) + mtime(dt) / 100000000.
  
   dt-1 = datetime(date(integer(truncate(dec-dt,0))),
                   integer((dec-dt - truncate(dec-dt,0)) * 100000000)).
   message dt skip
           dec-dt skip
           dt-1 skip
           view-as alert-box.

 

[Pramod Nair]

define variable dt as datetime no-undo.
define variable dec-dt as decimal no-undo decimals 8.
define variable dt-1 as datetime no-undo.

   dt = now.
   dec-dt = integer(date(dt)) + mtime(dt) / 100000000.
 
   dt-1 = datetime(date(integer(truncate(dec-dt,0))),
                   integer((dec-dt - truncate(dec-dt,0)) * 100000000)).
   message dt skip
           dec-dt skip
           dt-1 skip
           view-as alert-box.

working thanks a lot.