I want to insert the date and time into a sql database. Here is want I am
trying to do:
update hitclear
where table_id = 'reeldemand'
set cleardate = '#now#'
But, I get the following error:
Error Diagnostic Information
ODBC Error Code = 37000 (Syntax error or access violation)
[Microsoft][O
>
To: <[EMAIL PROTECTED]>
Sent: Monday, July 31, 2000 2:34 PM
Subject: Insert date and time into database
> I want to insert the date and time into a sql database. Here is want I am
> trying to do:
>
>
>
> update hitclear
> where table_id = 'reeldemand'
0 2:34 PM
To: [EMAIL PROTECTED]
Subject: Insert date and time into database
I want to insert the date and time into a sql database. Here is want I am
trying to do:
update hitclear
where table_id = 'reeldemand'
set cleardate = '#now#'
But, I get the following error:
Erro
Tim Bahlke, CIFO
thinkcreate.com
p. 336.230.0575
f. 336.230.0083
-Original Message-
From: Jacob [mailto:[EMAIL PROTECTED]]
Sent: Monday, July 31, 2000 2:34 PM
To: [EMAIL PROTECTED]
Subject: Insert date and time into database
I want to insert the date and time into a sql
, July 31, 2000 11:34 AM
Subject: Insert date and time into database
> I want to insert the date and time into a sql database. Here is want I am
> trying to do:
>
>
>
> update hitclear
> where table_id = 'reeldemand'
> set cleardate = '#now#'
>
&g
avoid confusion.
--K
> -Original Message-
> From: Jacob [SMTP:[EMAIL PROTECTED]]
> Sent: Monday, July 31, 2000 11:34 AM
> To: [EMAIL PROTECTED]
> Subject: Insert date and time into database
>
> I want to insert the date and time into a sql database. Here is
Removing the quotes did not work. I do not deal with adding dates to a
database to much, but when I do, it takes me a while to figure it out. I
went with plan B below. It works. Fine for what I need.
update hitclear
set cleardate = '#dateclear#', cleartime = '#timeclear#'
where table_id
7 matches
Mail list logo