hiroamano
Member
RE: OW Data in Sql
Hello,
I'm using this formula to convert to date that I can understand for f0911
table. I hope this help your problem. We are using SQL server so should
work on yours too.
select
dateadd(day, cast(gldgj as int)00-1,
'1/1/'+cast((left(gldgj,len(gldgj)-3)+1900) as varchar(15))) as date
from proddta.f0911
where gldgj>0
Hiro
ENT: SQL server 7.0 on NT 4
OW B7332
Hello,
I'm using this formula to convert to date that I can understand for f0911
table. I hope this help your problem. We are using SQL server so should
work on yours too.
select
dateadd(day, cast(gldgj as int)00-1,
'1/1/'+cast((left(gldgj,len(gldgj)-3)+1900) as varchar(15))) as date
from proddta.f0911
where gldgj>0
Hiro
ENT: SQL server 7.0 on NT 4
OW B7332