Click here to Skip to main content
15,792,510 members
Home / Discussions / Database
   

Database

 
QuestionRetail inventory management DB Design Pin
vineet123456713-Apr-21 0:42
vineet123456713-Apr-21 0:42 
AnswerRe: Retail inventory management DB Design Pin
Victor Nijegorodov13-Apr-21 1:54
Victor Nijegorodov13-Apr-21 1:54 
AnswerRe: Retail inventory management DB Design Pin
RedDk13-Apr-21 13:10
RedDk13-Apr-21 13:10 
QuestionRe: Retail inventory management DB Design Pin
Eddy Vluggen13-Apr-21 14:00
professionalEddy Vluggen13-Apr-21 14:00 
AnswerRe: Retail inventory management DB Design Pin
Mycroft Holmes14-Apr-21 14:32
professionalMycroft Holmes14-Apr-21 14:32 
QuestionConvert date, did I go too far Pin
jkirkerx8-Apr-21 13:50
professionaljkirkerx8-Apr-21 13:50 
AnswerRe: Convert date, did I go too far Pin
Victor Nijegorodov8-Apr-21 21:22
Victor Nijegorodov8-Apr-21 21:22 
AnswerRe: Convert date, did I go too far Pin
Richard Deeming8-Apr-21 23:03
mveRichard Deeming8-Apr-21 23:03 
Don't convert dates to strings in order to compare them. If you just want to ignore the time part, cast them to date instead:
SQL
CAST(b.startup_check_date As date) Between '20210401' And '20210431'
However, this will be non-SARGable. A better option would be to use:
SQL
(b.startup_check_date >= '20210401' And b.startup_check_date < '20210501')




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

GeneralRe: Convert date, did I go too far Pin
jkirkerx9-Apr-21 7:14
professionaljkirkerx9-Apr-21 7:14 
GeneralRe: Convert date, did I go too far Pin
Mycroft Holmes9-Apr-21 13:21
professionalMycroft Holmes9-Apr-21 13:21 
GeneralRe: Convert date, did I go too far Pin
jkirkerx9-Apr-21 15:20
professionaljkirkerx9-Apr-21 15:20 
GeneralRe: Convert date, did I go too far Pin
Richard Deeming11-Apr-21 22:10
mveRichard Deeming11-Apr-21 22:10 
AnswerRe: Convert date, did I go too far, Sort of solved Pin
jkirkerx10-Apr-21 15:06
professionaljkirkerx10-Apr-21 15:06 
QuestionExcel Spreadsheet To Database Migration Assistance Pin
Glen McHale7-Apr-21 0:55
Glen McHale7-Apr-21 0:55 
SuggestionRe: Excel Spreadsheet To Database Migration Assistance Pin
CHill607-Apr-21 1:57
mveCHill607-Apr-21 1:57 
AnswerRe: Excel Spreadsheet To Database Migration Assistance Pin
Mycroft Holmes7-Apr-21 13:54
professionalMycroft Holmes7-Apr-21 13:54 
QuestionSQLite query Pin
David Crow23-Mar-21 11:02
David Crow23-Mar-21 11:02 
AnswerRe: SQLite query Pin
k505423-Mar-21 15:42
mvek505423-Mar-21 15:42 
GeneralRe: SQLite query Pin
David Crow23-Mar-21 17:10
David Crow23-Mar-21 17:10 
AnswerRe: SQLite query Pin
Richard Deeming24-Mar-21 0:31
mveRichard Deeming24-Mar-21 0:31 
GeneralRe: SQLite query Pin
David Crow24-Mar-21 4:16
David Crow24-Mar-21 4:16 
QuestionDisallowed implicit conversion from data type smalldatetime to data type float Pin
jkirkerx18-Mar-21 12:56
professionaljkirkerx18-Mar-21 12:56 
AnswerRe: Disallowed implicit conversion from data type smalldatetime to data type float Pin
Victor Nijegorodov18-Mar-21 22:15
Victor Nijegorodov18-Mar-21 22:15 
GeneralRe: Disallowed implicit conversion from data type smalldatetime to data type float Pin
jkirkerx19-Mar-21 7:58
professionaljkirkerx19-Mar-21 7:58 
GeneralRe: Disallowed implicit conversion from data type smalldatetime to data type float Pin
jsc4219-Mar-21 8:45
professionaljsc4219-Mar-21 8:45 

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.