I'm trying to input some datas using preparedStatement and among those
coiumns one column is of type "smalldatetime" i wish to input the
current date and time at which i execute this query, how can i achieve
this in JDBC or what is the sql query for this.

I'm not sure if we're talking JET SQL or T-SQL or something else here? In
JET SQL you want the Date() function, something like ...

INSERT INTO Table1 ( TestDate )
SELECT Date() AS Expr1;

If you're using T-SQL you want the GETDATE() function, something like ...

INSERT INTO dbo.Table1
(TestDate)
SELECT GETDATE() AS Expr1

--
Brendan Reynolds
Access MVP

"srigoogle" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> I'm trying to input some datas using preparedStatement and among those
> coiumns one column is of type "smalldatetime" i wish to input the
> current date and time at which i execute this query, how can i achieve
> this in JDBC or what is the sql query for this.
>

Oops! Almost missed something! You want the time too, so you'll want to use
Now() rather than Date() in JET SQL.

--
Brendan Reynolds
Access MVP


"Brendan Reynolds" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
>
> I'm not sure if we're talking JET SQL or T-SQL or something else here? In
> JET SQL you want the Date() function, something like ...
>
> INSERT INTO Table1 ( TestDate )
> SELECT Date() AS Expr1;
>
> If you're using T-SQL you want the GETDATE() function, something like ...
>
> INSERT INTO dbo.Table1
> (TestDate)
> SELECT GETDATE() AS Expr1
>
> --
> Brendan Reynolds
> Access MVP
>
> "srigoogle" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
>> I'm trying to input some datas using preparedStatement and among those
>> coiumns one column is of type "smalldatetime" i wish to input the
>> current date and time at which i execute this query, how can i achieve
>> this in JDBC or what is the sql query for this.
>>
>
>