Re: VB & SAL Date/Time Problem?

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Dan Guzman (guzmanda_at_nospam-online.sbcglobal.net)
Date: 12/20/04 

Date: Mon, 20 Dec 2004 07:47:39 -0600

Consider using command parameters rather than building the datetime as a
string literal. This way, you don't need to be concerned with datetime
format settings. 

-- 
Hope this helps.
Dan Guzman
SQL Server MVP
"Richard Gutery" <rgutery@mentorits.com> wrote in message 
news:OE2l1gp5EHA.1392@tk2msftngp13.phx.gbl...
> I've written an ASP app that requires users to login - normal stuff.
>
> As is typical with users, sometimes they just close the browser which
> teminates the app. What I've done is created a new table in SQL that 
> inserts
> the date & time when a user logs in. All is well as other stuff.
>
> If the user then comes along and tries to log in again, I place this
> information into another table (for troubleshooting and reporting). 
> However
> the logic in my program prevents them from logging in again for some 
> period of time.
> I do a query against Active_Users table, and if the user id is in the 
> table, they cannot
> login again.
>
> We do this so that users don't run multiple copies of the browser
> (we know that users minimize stuff). Our app cannot allow users to
> log in more that once during an active session.
>
> What I'd like to be able to do is to delete an OLD record (say from
> yesterday in an ADMIN capacity) from the table based on the current
> date/time.
>
> My problem is that all records get deleted from the table based on the
> following SQL statement:
>
> StrSql = "DELETE FROM active_users WHERE Last_Seen <=' " &
> DateValue(StrOnlineTimedOut) & "'"
>
> Date/Time format in SQL: 2004-12-20 05:58:00.
> Format of StrOnlineTImedOut: 12/20/2004 6:18:20 AM
>
> Script looks like this (essentially StrOnlineTimedOut is 5 minutes from
> NOW):
> onlinedate = now()
> strTimeout = 1 (I actually pull this from another table, it's here for 
> clarity)
> StrOnlineTimedout = dateadd("n",-strtimeout*5,onlinedate)
>
> So I believe that what I need to do is to convert the date time format 
> from
> VB to an SQL format?
>
> Does anyone know of a VB Date/Time statement that will do this?
>
> Thanks in advance.
>
> RG
>
>
>

Relevant Pages

  • Re: Using variables in Dynamic SQL
    ... >converting datetime from character string." ... the CONVERT function in this piece of the code to format the date back to ... If you print the resulting string in @sql, you'll see that you have some ... DECLARE @StartDate datetime ...
    (microsoft.public.sqlserver.programming)
  • Re: Datetime comparison problem
    ... does datetime works fine for AM/PM format also? ... Links for SQL Server Books Online: ...
    (comp.databases.ms-sqlserver)
  • Re: Datetime comparison problem
    ... does datetime works fine for AM/PM format also? ... Links for SQL Server Books Online: ...
    (comp.databases.ms-sqlserver)
  • Re: VB & SAL Date/Time Problem?
    ... site you can format it as YYYYMMDD. ... > I've written an ASP app that requires users to login - normal stuff. ... > following SQL statement: ...
    (microsoft.public.sqlserver.programming)
  • RE: SqlCeEngine.CreateDataBase() - LCID - Datepart format problem
    ... Background info on why insert in your format doesn't work: ... datetime as string, SQL CE does an implicit convert from string to ... datetime formats with their style IDs are listed in CONVERT function in SQL ...
    (microsoft.public.sqlserver.ce)