| Subject | Need to store timestamp, but want to sometimes display date portion only | 
|---|---|
| Author | Clay Shannon | 
| Post date | 2005-03-21T15:43:59Z | 
How can I retrieve just the date portion of a timestamp field in SQL? IOW,
what do I need to do to get a value like "11/11/2001" instead of "11/11/2001
11:11:11 AM"?
 
Clay Shannon,
Dimension 4 Software
 
[Non-text portions of this message have been removed]
            what do I need to do to get a value like "11/11/2001" instead of "11/11/2001
11:11:11 AM"?
Clay Shannon,
Dimension 4 Software
[Non-text portions of this message have been removed]