date

Question

date

Mike Levan

SSChampion

Points: 14201
More actions
September 20, 2007 at 8:31 am

#125671

I have a column date(int) with values
75505
73637
74901
74105
73727

how can i find date range between 03/09/1998 and 09/12/2000

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 1

First thing we need to know is how the integer date value is computed. Looking at your data, I have no way of knowing what date 75505 (or any of the other values) represents.

Vladan SSC-Insane Points: 22072 More actions · Answer 2

No idea. You should first specify what the numbers in your INT column mean. The numbers you posted can mean anything - and I doubt anyone here has a functional crystal ball... but if you do, by all means let me know. It would be handy

Mike Levan SSChampion Points: 14201 More actions · Answer 3

Ok guys I got it by this

select

convert(char(10),cast(date - 36161 as datetime),101)from csuser.list

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 4

declare @startdate int,

@enddate int

set @startdate = datediff(dd, 0, '19980309') + 36161

set @enddate = datediff(dd, 0, '20000912') + 36161

select * from dbo.yourTable where date between @startdate and @enddate

David McFarland SSChampion Points: 11815 More actions · Answer 5

Are you sure it's 36161, jp? That seems like a rather arbitrary date that isn't the beginning of any julian variation I'm aware of (it's 1800-12-30).