Now() function in SQL??

[Jerome]

Hi,

Before I've queried my Access DB using ASP pages. The SQL string then
could contain: SELECT * FROM table1 WHERE date1>=Now().

This time round my DB is on a SQL Server and I'm still using ASP for
this. But now the Now() function returns an error message!? 'Now is not
a recognized function name'.

How do I tell the SQL Server then to only return future events in 'pure
SQL code'?? I saw the solution somewhere once, but can't find it back ...

Any help is appreciated!

Jerome

[Nicole Calinoiu]

Jerome,

GETDATE() is the SQL Server equivalent of Now().

HTH,
Nicole


"Jerome" <jherr@no.mnhn.spam.lu> wrote in message
news:uPwk2UOOEHA.1392@TK2MSFTNGP09.phx.gbl...

> Hi,
>
> Before I've queried my Access DB using ASP pages. The SQL string then
> could contain: SELECT * FROM table1 WHERE date1>=Now().
>
> This time round my DB is on a SQL Server and I'm still using ASP for this.
> But now the Now() function returns an error message!? 'Now is not a
> recognized function name'.
>
> How do I tell the SQL Server then to only return future events in 'pure
> SQL code'?? I saw the solution somewhere once, but can't find it back ...
>
> Any help is appreciated!
>
> Jerome

[el.c. - myLittleTools.net]

> could contain: SELECT * FROM table1 WHERE date1>=Now().

SELECT * FROM table1 WHERE date1>=GETDATE()

--
// myLittleTools.net : leading provider of web-based applications.
// myLittleAdmin : online MS SQL manager
// [url]http://www.mylittletools.net[/url]
// [email]webmaster@mylittletools.net[/email]

[Bob Barrows [MVP]]

Jerome wrote:

> Hi,
>
> Before I've queried my Access DB using ASP pages. The SQL string then
> could contain: SELECT * FROM table1 WHERE date1>=Now().
>
> This time round my DB is on a SQL Server and I'm still using ASP for
> this. But now the Now() function returns an error message!? 'Now is
> not a recognized function name'.
>

The equivalent T-SQL function is GETDATE()

SQL Books Online (usually referred to as BOL) is a great resource. If you've
installed the SQL Server client tools on your machine, it will be in the SQL
Server program group in your Windows Start menu.

It is available online at
[url]http://msdn.microsoft.com/library/en-us/startsql/portal_7ap1.asp[/url]

And a downloadable version is available at:
[url]http://www.microsoft.com/downloads/details.aspx?FamilyID=a6f79cb1-a420-445f-8a4b-bd77a7da194b&displaylang=en[/url]

Bob Barrows
--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.

[Jeswanth Jaishanker]

use getdate() instead of now.
"Jerome" <jherr@no.mnhn.spam.lu> wrote in message
news:uPwk2UOOEHA.1392@TK2MSFTNGP09.phx.gbl...

> Hi,
>
> Before I've queried my Access DB using ASP pages. The SQL string then
> could contain: SELECT * FROM table1 WHERE date1>=Now().
>
> This time round my DB is on a SQL Server and I'm still using ASP for
> this. But now the Now() function returns an error message!? 'Now is not
> a recognized function name'.
>
> How do I tell the SQL Server then to only return future events in 'pure
> SQL code'?? I saw the solution somewhere once, but can't find it back ...
>
> Any help is appreciated!
>
> Jerome

[Aaron [SQL Server MVP]]

> This time round my DB is on a SQL Server and I'm still using ASP for

> this. But now the Now() function returns an error message!?

Well, yeah. SQL Server != Access! (Sorry, in Access, that would be, SQL
Server <> Access!) ;-)

Now() and GETDATE() and CURRENT_TIMESTAMP are covered here, which might make
for useful reading in general:
[url]http://www.aspfaq.com/2214[/url]

--
[url]http://www.aspfaq.com/[/url]
(Reverse address to reply.)