freetds AT lists.ibiblio.org
Subject: FreeTDS Development Group
List archive
- From: "Mark Roedel" <MarkRoedel AT letu.edu>
- To: "TDS Development Group" <freetds AT franklin.oit.unc.edu>
- Subject: RE: March 16th 2025 from Microsoft SQL Server
- Date: Fri, 29 Jun 2001 14:59:16 -0500
> -----Original Message-----
> From: James Cameron [mailto:cameron AT stl.dec.com]
> Sent: Friday, June 29, 2001 12:55 AM
> To: TDS Development Group
> Subject: [freetds] March 16th 2025 from Microsoft SQL Server
>
>
> Problem: some datetime fields are returned by FreeTDS as
> "Mar 16 2025 12:56PM". I don't know if they are NULLs or
> not, but they correspond to field values that are shown by
> other software as just not being set. I would expect them
> to return a NULL somehow. How? Can I test them for being
> NULL using SQL? How?
I haven't had a need to use it yet with MS SQL, but the syntax for doing
this in both MySQL and Informix would be (if I'm remembering correctly):
select * from mytable where datefield is not NULL
(Yeah. "Is not", not <>.)
---
Mark Roedel (roedelm AT letu.edu) || "There cannot be a crisis next week.
Systems Programmer / WebMaster || My schedule is already full."
LeTourneau University || -- Henry Kissinger
-
March 16th 2025 from Microsoft SQL Server,
James Cameron, 06/29/2001
- <Possible follow-up(s)>
- RE: March 16th 2025 from Microsoft SQL Server, Mark Roedel, 06/29/2001
Archive powered by MHonArc 2.6.24.