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