Inserting date and time to a 8,0 numeric field in sql

[dcutaia]

How do I insert the date and time into a 8,0 field using SQL.

insert into library/file name (IRDEPD,IRDEPT)
values(current date,current time)

Thanks,

DAC

[DeadManWalks]

Re: Inserting date and time to a 8,0 numeric field in sql

Dec(Replace(Char(Current_Date,iso),'-',''),8,0)) )

[B.Hauser]

Re: Inserting date and time to a 8,0 numeric field in sql

If you are on release 7.1 you can also use the following function:

Int(VarChar_Format(Current_Timestamp, 'YYYYMMDD')), 
Int(VarChar_Format(Current_Timestamp, 'HH24MISS'))

And if you are already on release 7.2 - SQL can convert a date, time or timestamp value into a numeric value by using one of the functions BIGINT, INT or DEC

Int(Current_Date), Dec(Current_Date, 8, 0)
Int(Current_Time), Dec(Current_Time, 6, 0)

Birgitta

[B.Hauser]

Re: Inserting date and time to a 8,0 numeric field in sql

Deleted!!!