Click here to Skip to main content
15,501,342 members
Home / Discussions / Database
   

Database

 
AnswerRe: sql server Pin
saharmirzaei23-Jul-14 23:30
Membersaharmirzaei23-Jul-14 23:30 
GeneralRe: sql server Pin
PIEBALDconsult23-Jul-14 9:32
professionalPIEBALDconsult23-Jul-14 9:32 
GeneralRe: sql server Pin
saharmirzaei23-Jul-14 23:26
Membersaharmirzaei23-Jul-14 23:26 
AnswerRe: sql server Pin
Bernhard Hiller23-Jul-14 21:49
MemberBernhard Hiller23-Jul-14 21:49 
GeneralRe: sql server Pin
saharmirzaei23-Jul-14 23:23
Membersaharmirzaei23-Jul-14 23:23 
AnswerRe: sql server Pin
Mycroft Holmes23-Jul-14 23:47
professionalMycroft Holmes23-Jul-14 23:47 
QuestionWeird MS SQL "Error" Pin
GenJerDan23-Jul-14 8:07
MemberGenJerDan23-Jul-14 8:07 
AnswerRe: Weird MS SQL "Error" Pin
Richard Deeming23-Jul-14 8:47
mveRichard Deeming23-Jul-14 8:47 
Are you absolutely sure that that's the precise query that you executed, and that the row you're looking at is the one it updated?

smalldatetime[^] will round to the nearest minute, but it will only round up if the seconds are greater than or equal to 29.999; anything else will round down.
SQL
SELECT
    CAST('7/23/2014 9:49:29.998 AM' as smalldatetime),
    CAST('7/23/2014 9:49:29.999 AM' as smalldatetime)
;

/*
Output:
2014-07-23 09:49:00
2014-07-23 09:50:00
*/




"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer


GeneralRe: Weird MS SQL "Error" Pin
GenJerDan23-Jul-14 9:10
MemberGenJerDan23-Jul-14 9:10 
GeneralRe: Weird MS SQL "Error" Pin
Richard Deeming23-Jul-14 9:18
mveRichard Deeming23-Jul-14 9:18 
GeneralRe: Weird MS SQL "Error" Pin
GenJerDan23-Jul-14 9:28
MemberGenJerDan23-Jul-14 9:28 
AnswerRe: Weird MS SQL "Error" Pin
jschell23-Jul-14 12:55
Memberjschell23-Jul-14 12:55 
AnswerRe: Weird MS SQL "Error" Pin
Bernhard Hiller23-Jul-14 22:01
MemberBernhard Hiller23-Jul-14 22:01 
GeneralRe: Weird MS SQL "Error" Pin
GenJerDan24-Jul-14 4:14
MemberGenJerDan24-Jul-14 4:14 
QuestionCONCAT names with condition Pin
Jassim Rahma20-Jul-14 12:51
MemberJassim Rahma20-Jul-14 12:51 
AnswerRe: CONCAT names with condition Pin
Mycroft Holmes20-Jul-14 13:53
professionalMycroft Holmes20-Jul-14 13:53 
GeneralRe: CONCAT names with condition Pin
PIEBALDconsult20-Jul-14 15:11
professionalPIEBALDconsult20-Jul-14 15:11 
AnswerRe: CONCAT names with condition Pin
GuyThiebaut20-Jul-14 22:35
professionalGuyThiebaut20-Jul-14 22:35 
QuestionFatal error encountered during command execution while executing Mysql query Pin
ven75319-Jul-14 20:42
Memberven75319-Jul-14 20:42 
QuestionThe Log For the Database is Not Available Pin
Prakash S19-Jul-14 1:58
MemberPrakash S19-Jul-14 1:58 
AnswerRe: The Log For the Database is Not Available Pin
Andrius Leonavicius19-Jul-14 14:40
professionalAndrius Leonavicius19-Jul-14 14:40 
GeneralRe: The Log For the Database is Not Available Pin
Prakash S20-Jul-14 21:08
MemberPrakash S20-Jul-14 21:08 
GeneralRe: The Log For the Database is Not Available Pin
Andrius Leonavicius21-Jul-14 4:01
professionalAndrius Leonavicius21-Jul-14 4:01 
AnswerRe: The Log For the Database is Not Available Pin
Kornfeld Eliyahu Peter19-Jul-14 23:54
professionalKornfeld Eliyahu Peter19-Jul-14 23:54 
QuestionHow to select persons who didn't pay they'r bill for two mounth Pin
mohammadkaab18-Jul-14 6:57
Membermohammadkaab18-Jul-14 6:57 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.