> I have a date field that I need to convert; It comes through as the
> number of days since 1/1/1800... It comes from a Unix/COBOL sequential
> database file, and performance is key, because there's 67,000 master
> records, each with 3 or 4 of these fields, and then there are 8 other
> supporting tables which each have some of these fields as well.
>
> * The data is going into SQL 7... Maybe some sort of SQL trick to
> convert the numbers to a date??? I'd like that, but can't quite see
> how it'd be done.
Well
select dateadd(day, 2, '1/1/1800')
seems to do the right thing.
Jenda
== [EMAIL PROTECTED] == http://Jenda.Krynicky.cz ==
: What do people think?
What, do people think? :-)
-- Larry Wall in <[EMAIL PROTECTED]>
_______________________________________________
ActivePerl mailing list
[EMAIL PROTECTED]
http://listserv.ActiveState.com/mailman/listinfo/activeperl
