Can you post the table definition, some sample data (click on the first link in my signature block for a quick means of doing just this), expected results, and what...

Care to give an example and...

Roy Ernest (10/28/2010)

---

Grant Fritchey (10/28/2010)

---

Oh, that was you? Sorry I didn't wave back. Man, I...

Jeff Moden (10/28/2010)

---

Ok... first one is done. I liked Paul's idea of "Phil McCracken" as the author. Please see attached just for a preview. Steve, I'll post...

Look at this, and with slight modification you should be able to do what you require

https://www.sqlservercentral.com/blogs/lynnpettis/archive/2009/03/25/some-common-date-routines.aspx

Here is a snippet of code (copied from a post long ago, by Jeff Moden)

It works for me

/*Import Excel OpenRowsetSelect data from excel

note Sheet1$a4:C start at row 4 using...

Thie above is from your first posting and does NOT agree with the sample code you posted. My...

If your data were being imported into a staging table, then the datetime values, could be converted to time only as a VARCHAR and then inserted into the proper...

To receive tested help, please post the table, view definition, some test data and expected results and what code you have used.

In order to do that easily please...

In the manner of a general reply, assuming you may wish to have a "bag of date tips and all, try this link, and you can add the T-SQL to...

You might receive some assistances if you defined your table(s), provided some sample data and desired results. Please refer to the fist link in my signature block for what...

Not one of those guys .. that is straight out of college, but have been around long enough to know, that if you are not learning new technologies, you are...

I passed your thanks onto the Author Gianluca Sartori (as noted in the code posted) and requested that he look at this forum and just maybe he can come up...

First of all without the table structuresand some sample data it is impossible to give you a tested answer.

All I can suggest is that you use Books On Line...

Gail,

at first I thought those answers / explanations were jokes, but then realized they were not. May the Gods save us from the stupidies of those who think...