RE: VB & SAL Date/Time Problem?
From: Alejandro Mesa (AlejandroMesa_at_discussions.microsoft.com)
Date: 12/20/04
- Next message: Jorge Luzarraga Castro: "string truncated"
- Previous message: dw: "Select column names + values in query analyzer"
- In reply to: Richard Gutery: "VB & SAL Date/Time Problem?"
- Messages sorted by: [ date ] [ thread ]
Date: Mon, 20 Dec 2004 06:33:06 -0800
Or (better is to do it following Uri and Dan recommendations. Create a stored
procedure and call it using ADO command object) you can format the datetime
value as "yyyy-mm-ddThh:mm:ss" (ISO8601, See CONVERT in BOL) and sql server
will interprete it as a datetime value independently of the date format set
in your server.
AMB
"Richard Gutery" wrote:
> 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
>
>
>
>
- Next message: Jorge Luzarraga Castro: "string truncated"
- Previous message: dw: "Select column names + values in query analyzer"
- In reply to: Richard Gutery: "VB & SAL Date/Time Problem?"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
