Hi,

I have 1 table with 3 column(session(eg:1),start(eg: 8:00:00 AM),end (eg:10:00:00 AM)
I want to determine which session I'm in now by using sql statement,
just like this :

time = date.now

"select session from table1 where time > start and time < end"

Is it works ? or there is another way to make it?..thanks

__________________
Suzila

You could also use BETWEEN .. but yes- that pseudo code looks about right.

Hal Levy
Web Developer, PDI Inc.

NOT a Wiley/Wrox Employee

yes, the logic is seem like to correct but the main problem are, the sql statement cannot compare the 'time' with 'start'

time = '8:00:00 AM'(current time) so do start = 8:00:00 AM( database)
('ive try use convert and cast)

anyone knows? i'm using sql server..thanks a lot

what do you mean it can't compare it.. what kind of error are you getting?


Hal Levy
Web Developer, PDI Inc.

NOT a Wiley/Wrox Employee

yes, it can't compare it.
I didn't get any error but it didn't produce any output..
I'm using convert.. like this : convert(datetime,time,9)
9 - because i'm using AM and PM

Please paste your sql statement here for review.

Hal Levy
Web Developer, PDI Inc.

NOT a Wiley/Wrox Employee

column 1 : session (eg: 1),
column 2 :start (eg: 8:00:00 AM),
column 3: end (eg:10:00:00 AM)

t= date.now

SELECT session, CONVERT(datetime, start, 9) AS start, CONVERT(datetime, end, 9) AS end
FROM dbo.sessi
WHERE (end > (CONVERT(datetime, t, 9))) AND (start < =(CONVERT(datetime, t, 9)))

i just solve my problem,
my solution like this

SELECT session
FROM dbo.sessi
WHERE
(start < CONVERT(varchar(30), GETDATE(), 114)) AND (end > CONVERT(varchar(30), GETDATE(), 114))

thank you for help me..:D