473,326 Members | 2,111 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,326 software developers and data experts.

datetime=null return minvalue

I am using a DAL and i want to pass a date to another class,
the date can be en normal date or null
I send the date as an object, because datetime can't be null

But when the date is saved in the database, i get the minvalue (1/01/1900) of the datertime and not null

how can i put an empty date in the database?

---
Posted using Wimdows.net NntpNews Component -

Post Made from http://www.DotNetJunkies.com/newsgroups Our newsgroup engine supports Post Alerts, Ratings, and Searching.
Nov 18 '05 #1
0 969

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

7
by: JJ | last post by:
Hi, What's the correct code for checking if a DateTime control is empty or not filled in with a date? Thanks, JJ
2
by: John S | last post by:
Does anyone know why the dataset blows up when it is reading a column that is defined at DateTime and there are null values or empty strings?
2
by: Rey | last post by:
Howdy all. My problem deals w/inserting nulls into database (SQL Svr 2K) for the datetime fields activityDate and followUpDate where nulls are allowed. >From the web form, the user can type...
1
by: Jake | last post by:
Hi All, I have an object that ahs a property of time dateTime, this property is set to the contents of a DateTime field in the database(SQL Server). The problem I am haveing is that if the...
2
by: George Jin | last post by:
In the Datagrid clolumns there is one is DateTime Type. It always shows DateTime.MinValue. How can It show emptty string instead? I Know I can do conversion from DateTime to string before binding...
3
by: hecsan07 | last post by:
How do I set a date field to null in C#? HS
4
by: Mark | last post by:
It's my understanding that the code below will create a session cookie (RAM based cookie) that does not persist to a file, but exists in memory on the client's pc and will be deleted when the...
4
by: shapper | last post by:
Hello, I have the following: DateTime c = database.Posts.Max(b =b.CreatedAt).Value; b.CreatedAt is of type "DateTime?" The problem is when database.Posts is empty. I get an error:...
1
pbala
by: pbala | last post by:
ConnectionString = "....." QueryString = "SELECT * FROM SomeTable" Dim myConnection As New MySql.Data.MySqlClient.MySqlConnection(ConnectionString) Dim myCommand As New...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.