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

Database

 
GeneralRe: ibtogo64.dll error Pin
Richard MacCutchan25-Sep-22 9:03
mveRichard MacCutchan25-Sep-22 9:03 
GeneralRe: ibtogo64.dll error Pin
Dhyanga25-Sep-22 9:15
Dhyanga25-Sep-22 9:15 
GeneralRe: ibtogo64.dll error Pin
Richard Deeming25-Sep-22 22:45
mveRichard Deeming25-Sep-22 22:45 
QuestionJust trying to get the count that meets the criteria Pin
jkirkerx4-Sep-22 14:58
professionaljkirkerx4-Sep-22 14:58 
AnswerRe: Just trying to get the count that meets the criteria Pin
CHill605-Sep-22 3:28
mveCHill605-Sep-22 3:28 
GeneralRe: Just trying to get the count that meets the criteria Pin
jkirkerx5-Sep-22 9:11
professionaljkirkerx5-Sep-22 9:11 
GeneralRe: Just trying to get the count that meets the criteria Pin
jkirkerx5-Sep-22 9:41
professionaljkirkerx5-Sep-22 9:41 
GeneralRe: Just trying to get the count that meets the criteria Pin
CHill605-Sep-22 22:05
mveCHill605-Sep-22 22:05 
Quote:
what's stored in the database (SQL Server) as a Date or DATETIME column, is just a string formatted to a particular ISO format, labeled as something special or unique.
Nope - it's stored on the database as a date in 3 bytes and no formatting takes place at all - formatting of dates only takes place when they are being displayed.

This article explains further How SQL Server stores data types: dates and times - Born SQL[^]
Quote:
I needed a consistent way of working with dates already written, so I choose the ISO120 format. ISO120 just makes it easier to fabricate new dates, and do comparisons in PHP8.
You might want to rethink that and make sure you are using the latest version of PHP 8.

I know there were some issues around creating date objects from strings, but this is the first time I've heard anyone claim it has problems with SQL dates. Your problems are probably arising from incorrectly storing the date as a string.

Quote:
I didn't want to change the database because it has 26 gigs of data.
Tbh that's not very big. If it was me I would bite that bullet - as long as there is nothing else using the database (including MI teams). Actually, even then I would probably still go for it.
GeneralRe: Just trying to get the count that meets the criteria Pin
CHill605-Sep-22 22:07
mveCHill605-Sep-22 22:07 
GeneralRe: Just trying to get the count that meets the criteria Pin
jkirkerx6-Sep-22 6:37
professionaljkirkerx6-Sep-22 6:37 
GeneralRe: Just trying to get the count that meets the criteria Pin
Richard Deeming6-Sep-22 22:23
mveRichard Deeming6-Sep-22 22:23 
GeneralRe: Just trying to get the count that meets the criteria Pin
jkirkerx7-Sep-22 7:22
professionaljkirkerx7-Sep-22 7:22 
GeneralRe: Just trying to get the count that meets the criteria Pin
CHill608-Sep-22 0:59
mveCHill608-Sep-22 0:59 
QuestionMSSQL select values in one row by group Pin
Sergey Makarov 20222-Sep-22 6:45
Sergey Makarov 20222-Sep-22 6:45 
AnswerRe: MSSQL select values in one row by group Pin
OriginalGriff2-Sep-22 6:47
mveOriginalGriff2-Sep-22 6:47 
GeneralRe: MSSQL select values in one row by group Pin
Sergey Makarov 20222-Sep-22 6:49
Sergey Makarov 20222-Sep-22 6:49 
QuestionAzure Synapse Data Flow Linked Data Set table not populating Pin
j11codep2-Sep-22 3:38
j11codep2-Sep-22 3:38 
GeneralAnyone here use Snowflake Pin
Mike Ahrens30-Aug-22 10:37
professionalMike Ahrens30-Aug-22 10:37 
GeneralRe: Anyone here use Snowflake Pin
PIEBALDconsult30-Aug-22 13:57
professionalPIEBALDconsult30-Aug-22 13:57 
GeneralRe: Anyone here use Snowflake Pin
Mycroft Holmes30-Aug-22 13:59
professionalMycroft Holmes30-Aug-22 13:59 
GeneralRe: Anyone here use Snowflake Pin
PIEBALDconsult30-Aug-22 14:22
professionalPIEBALDconsult30-Aug-22 14:22 
GeneralRe: Anyone here use Snowflake Pin
CHill601-Sep-22 4:25
mveCHill601-Sep-22 4:25 
GeneralRe: Anyone here use Snowflake Pin
CHill601-Sep-22 4:23
mveCHill601-Sep-22 4:23 
RantRe: Anyone here use Snowflake Pin
Eddy Vluggen1-Sep-22 4:49
professionalEddy Vluggen1-Sep-22 4:49 
GeneralRe: Anyone here use Snowflake Pin
Mike Ahrens1-Sep-22 11:34
professionalMike Ahrens1-Sep-22 11:34 

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.