It's not a secret anymore!*
The moose likes JDBC and the fly likes SqlServ er Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "SqlServ er" Watch "SqlServ er" New topic

SqlServ er

Graham Thorpe
Ranch Hand

Joined: Mar 25, 2002
Posts: 265
Hi everybody
I have small doubt query on Sql Server
I wrote like this query in Query analyser.I created one table named dd"
create table dd(dt date/time);
After that when i insert this query
"insert into dd values('')"
Then i get the result date "1900-01-01 00:00:00.000".So what is the reason this date will come ..
With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime.
subject: SqlServ er
Similar Threads
Inserting date in database
Date 01/01/1970 returning non-zero value for time
Insert a Date into DB JDBC
Date comparision in SQL from timestamp
duplicate created in AUTO INCREMENT in mysql if its possible?