Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Null - Blank DateTime value
Message
From
07/06/2006 20:59:35
Scott Butts
Ims Specialty Services
Twin Falls, Idaho, United States
 
 
To
07/06/2006 19:34:45
General information
Forum:
ASP.NET
Category:
Coding, syntax and commands
Environment versions
Environment:
C# 2.0
OS:
Windows XP SP2
Database:
MS SQL Server
Miscellaneous
Thread ID:
01127723
Message ID:
01127739
Views:
9
Thank You Michel

Scott

>>I am trying to convert some data from a Foxpro table to a sql database. One of the fields is a string time field in Foxpro (09:15) and a datetime field in sql. I am using the DateTime.Parse() command to convert the string values to datetime values. Everything is working fine until I hit a field that is blank. How to I generate a blank, null.... what every the correct word is, value to insert into the sqltable? In Foxpro DTOT({}) would give me a blank datetime variable.
>
>The following returns an empty date:
>
>
>        ' Return an empty date
>        ' expT1 Date
>        Public Function GetEmptyDate() As Date
>            Return New Date(1899, 12, 30, 0, 0, 0)
>        End Function
>
Previous
Reply
Map
View

Click here to load this message in the networking platform