Re: Java Datetime Strategies with SqlServer

From: Sampsa Sohlman (sampsa_sohlman_at_hotmail.com)
Date: 05/13/04 

Date: Thu, 13 May 2004 10:20:36 +0300

Ian Walsh wrote:
> 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.

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 

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

Relevant Pages

  • Java Datetime Strategies with SqlServer
    ... I'm new to Java (from a .Net background) and I'm having problems ... inserting a 'datetime' field into a SqlServer Database. ...
    (comp.lang.java.databases)
  • Re: Java Datetime Strategies with SqlServer
    ... Ian Walsh schrieb: ... > inserting a 'datetime' field into a SqlServer Database. ...
    (comp.lang.java.databases)
  • Re: timestamps as part of a primary or foreign key.
    ... no two threads will every be inserting at the same time, ... and note that the DATETIME value is accurate only ... guarantee that your insert rate was serialized to ... two/second. ...
    (comp.databases.sybase)
  • Re: Problem with Insert and Datetime
    ... The colums defined as datetime. ... Dim cmd As New SqlCeCommand ... > I can think of is that you are either really inserting Jan 1, ...
    (microsoft.public.sqlserver.ce)
  • Storing appostrophes in SQL
    ... I want to save it to a SQLServer database ... If the user types in <Here's Johnny!>, ... it into SQLServer by inserting the text string <Here''s ... process the text string before I insert it to double all ...
    (microsoft.public.excel.programming)