Re: How do I Convert a Date/Time Field to Just a Date Field?
From: jj (jjj.nosspam_at_mindspring.com)
Date: 08/26/04
- Next message: Al: "RE: ESP and chinese character problem"
- Previous message: Dominic Godin: "Indexing results from a stored proc"
- In reply to: Tibor Karaszi: "Re: How do I Convert a Date/Time Field to Just a Date Field?"
- Messages sorted by: [ date ] [ thread ]
Date: Thu, 26 Aug 2004 12:47:59 GMT
Thanks to everyone for your help. Much appreciated. Also, just to
clarify, I don't mind using a time value in my "converted" date/time, so
long as the time value is 00:00:00. In fact, I assumed that would be
what it was. I just needed to change the actual hours/minutes to
"zeros", so I could just work with the "date" portion.
Again, many thanks.
jj
Tibor Karaszi wrote:
> Note that the suggestions (which are all valid) either returns a string (which is not of datetime datatype) or
> a datetime value with the time set to 00:00:00. It is impossibly to have datetime without a time value in SQL
> Server, as no such datatype exists in SQL Server. You might want to read my article at
> http://www.karaszi.com/SQLServer/info_datetime.asp which explains this more detailed and also have examples of
> how to work against datetime data, and common mistakes and misunderstandings.
>
- Next message: Al: "RE: ESP and chinese character problem"
- Previous message: Dominic Godin: "Indexing results from a stored proc"
- In reply to: Tibor Karaszi: "Re: How do I Convert a Date/Time Field to Just a Date Field?"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
