Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How will i store empty date and time.
Message
From
24/05/2005 18:32:47
Dragan Nedeljkovich (Online)
Now officially retired
Zrenjanin, Serbia
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 8 SP1
OS:
Windows 2000 SP4
Network:
Windows 2000 Server
Database:
MS SQL Server
Miscellaneous
Thread ID:
01016986
Message ID:
01017316
Views:
23
Ah, I thought I saw some spaces in your example. Four characters, can't go shorter.

Yes, the value per character is very subtle... on my keyboard, the slash is on shift+7, so for me it's one shift less, plus it looks like a much nicer, high-brow smiley... :)

Aren't we a nitpicking lazy bunch?

>I didn't know you could do it that way, thanks. However, as to it's shortness, it still appears to have a character length of 4. <g>
>
>>>Not in SQL Server, NULL is as close as you can get with either datetime or smalldatetime. SQL Server doesn't have anything like VFP's {/:} (empty datetime).
>>
>>Try
{ :}
. That's even shorter :).

back to same old

the first online autobiography, unfinished by design
What, me reckless? I'm full of recks!
Balkans, eh? Count them.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform