VB to SQL

[Gary.Lowe]

Hi All

I need to be able to chenge this

If TimeValue(Time) <= TimeValue(TimeSerial(mvarSessionStartTime, 0, 0)) Then
        SessionDate = DateAdd("d", -1, Date)
    Else
        SessionDate = Date
    End If

to a SQL equivilant in a stored procedure


Does anyone have any ideas. SQL doesn't seem to have the vb equivilant functions.

Thanks

[Virgil J. Schmidt]

Perhaps I'm missing something here, but would this work

IF GETDATE() <= @DateValue

@NewDate = DATEADD(d, -1, GETDATE())

ELSE

@NewDate = GETDATE()

END IF

Where @DateValue is a passed value and @NewDate is a variable declared in the stored procedure.

I think the following is possible, but I can't make it work unless converting the date to an integer)...

Instaed of @NewDate, you could just have the stored procedure return the value...

return DATEADD(d, -1, GETDATE())


I don't know how to post code as you did. How do you do that?

[Gary.Lowe]

Thanks Virgil