Select datetime data from SQL Server colum?

Try: select next_update_time from bgrex_updatequeue where next_update_time.

Already tried this, gives this error---The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value. – Asad Butt Dec 17 '09 at 20:34 2 No, you tried '18/12/2009'. '2009-12-18' is a different expression entirely, and one that should convert correctly.

– Joel Coehoorn Dec 17 '09 at 20:42 Thanks mate, was my fault, works fine – Asad Butt Dec 17 '09 at 20:44.

Try universal SQL Date Format YYYYMMDD WHERE NEXT_UPDATE_TIME.

If you are using a DataView, it can be accomplished easily doing this (for example between dates): myDataView = new DataView(myDataSet. Tables"TABLE", "TIMESTAMP >= '" + Convert. ToDateTime(fromDate) + "' AND TIMESTAMP ToDateTime(toDate) + "'", "TIMESTAMP", DataViewRowState.

CurrentRows); toDate and fromDate are of type string There is also an article on Working with SQL Server Date/Time Variables: Part Three - Searching for Particular Date Values and Ranges.

This should work : SELECT NEXT_UPDATE_TIME FROM BGREX_UpdateQueue WHERE NEXT_UPDATE_TIME.

I don't mind a down vote, but you might want to let me know what I've gotten wrong. I am always happy to learn more when I am mistaken. – Jay Zeng Dec 24 '09 at 0:57.

The query in your example is missing quotes around the date, it should be: SELECT NEXT_UPDATE_TIME FROM BGREX_UpdateQueue WHERE NEXT_UPDATE_TIME.

Same as @ angry jim – Asad Butt Dec 17 '09 at 20:38 @asdi: then use a date format that your server expects, 'dd MMM yyyy' always works ('18 Dec 2009') – Rory Dec 17 '09 at 20:39 thanks it was suppose to be '2009-12-18' – Asad Butt Dec 17 '09 at 20:45.

I cant really gove you an answer,but what I can give you is a way to a solution, that is you have to find the anglde that you relate to or peaks your interest. A good paper is one that people get drawn into because it reaches them ln some way.As for me WW11 to me, I think of the holocaust and the effect it had on the survivors, their families and those who stood by and did nothing until it was too late.