BI Architect Bill Pearson launches a set of articles surrounding a group of MDX functions specialized to meet the pervasive business need to analyze data within the context of time / date. In this article, we will overview the PeriodsToDate() function, and then we will introduce "shortcut" functions that are based upon it.
2015-06-17
8,458 reads
declare @mydt varchar(10) set @mydt = '10/10/2003' declare @newdt datetime set @newdt = Convert(datetime, @mydt) SELECT CONVERT(varchar(25),getdate(),2) SELECT CONVERT(varchar(30),@newdt,109) SELECT CONVERT(datetime,@mydt) SELECT CONVERT(datetime,'10/10/2003',103) SELECT CONVERT(datetime,@mydt,103) SELECT CAST(CONVERT(char(10), getdate(), 112) as datetime)Test the code above and you'll see that the last 3 select statements (which roughly correspond to the previous replies in this thread) all produce […]
2004-07-14
18 reads
By Steve Jones
Thanks to everyone that came to my talks. Slides are below. Best Practices for...
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers