skip to main | skip to sidebar

MSSQL101

Thursday, November 16, 2017

number to datetime

convert(datetime ,43040.379150544 )
Till Next Time

Posted by John Minkjan at 6:38 AM

Labels: CONVERT, MSSQL, SCRIPT, TSQL

No comments:

Older Post Home

Subscribe to: Post Comments (Atom)

Blog Archive

▼ 2017 (4)
- ▼ November (2)
  - number to datetime
  - image to varchar
- ► September (2)

► 2014 (3)
- ► April (3)

► 2013 (3)
- ► August (1)
- ► January (2)

► 2010 (4)
- ► November (1)
- ► August (1)
- ► June (2)

► 2009 (6)
- ► August (1)
- ► February (2)
- ► January (3)

► 2008 (8)
- ► December (6)
- ► August (1)
- ► February (1)

About Me

John Minkjan: I'm a senior BI advisor / Lead Data Sceintist at Oktober in the Netherlands.

View my complete profile

Labels

AGENT (1)
ALL POSTS (13)
BACKUP (2)
COLUMN (1)
CONNECT (1)
CONVERT (2)
CURSOR (2)
DATE (2)
DRIVE (1)
DRIVES (1)
FOREIGN KEY (1)
FREESPACE (1)
GRANTS (1)
INDEX (1)
JOBAGENT (1)
LINKED SERVER (2)
MSSQL (21)
OUTPUT (1)
Package Store (1)
PERMISSIONS (1)
RESTORE (3)
ROWCOUNT (2)
SCHEDULER (1)
SCRIPT (4)
SSIS (1)
SYNONYM (1)
TSQL (6)
UPDATE (1)
VARIABLE (1)

My Blog List

MDX101

Past 12 months dynamic - {StrToMember("[Kalender].[J4MND].[Jaar 4MND Maand].&["+Format(DATEADD("M" ,-1,now()),"yyyyMM")+ "]").Lag(11):StrToMember("[Kalender].[J4MND].[Jaar 4MND Maan...