• Introducing Dark Mode! Switch by clicking on the lightbulb icon next to Search or by clicking on Default style at the bottom left of the page!

RE: OW Data in Sql

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
 
Top