Skip to navigation
Take a 112 SQL server date like '20200101' and add 455 days to it
22.09.23
```sql ,IIF(last_sale = 0, CONVERT(VARCHAR(8),DATEADD(day,-455,CONVERT(datetime,q.qb_created,112)), 112) ,CONVERT(VARCHAR(8),DATEADD(day,-455,CONVERT(datetime,last_sale,112)), 112)) AS dead_since ```
Reply
Anonymous
Information Epoch 1732396793
Looking for the ninety percent solution.
Home
Notebook
Contact us