Java Datetime Strategies with SqlServer

Thread view:

Ian Walsh - 12 May 2004 14:24 GMT

Hi,

I'm new to Java (from a .Net background) and I'm having problems
inserting a 'datetime' field into a SqlServer Database. I can insert a
date (01/01/2004) and a time (eg 01/01/1970 15:23) but not a Datetime
(eg 01/01/2004 15:23).

Can I do this using Java.Sql? If not, what is the usual strategy for
inserting datetime values into a SqlServer database.

All help appreciated.

Thanks.

Reply to this Message

Michael Rauscher - 12 May 2004 16:37 GMT

Ian Walsh schrieb:

> Hi,
>
[quoted text clipped - 7 lines]
>
> All help appreciated.

Try java.sql.Timestamp.

Bye
Michael

Reply to this Message

Sampsa Sohlman - 13 May 2004 08:20 GMT

> Hi,
>
[quoted text clipped - 7 lines]
>
> All help appreciated.

1. Use PreparedStatements ( see java.sql.PreparedStatement )
2. Use Timestamp to handle Date ( see java.sql.Timestamp )

This way you don't have to care date format, just handle the time.

- Sampsa

Signature

-------------------------------------------
// Sampsa Sohlman //
// My email can be found on my homepage //
// http://sampsa.sohlman.com //
-------------------------------------------

Reply to this Message

Free Magazines

Get these publications absolutely FREE for up to 12 months. There are no hidden fees and no obligation. Simply choose a title, complete the application form and submit it. Read more ...