Import Excel Ke MySQL Dengan PHP

https://www.malasngoding.com/import-excel-ke-mysql-dengan-php/

Cara Main 3DS pakai emulator Citra

https://www.youtube.com/watch?v=ea1lejyL6K8

Manipulasi tanggal di sql server

Manipulasi tanggal di sql server :

Sumber -> https://blog.sqlauthority.com/2007/08/18/sql-server-find-last-day-of-any-month-current-previous-next/

----Last Day of Previous Month
SELECT DATEADD(s,-1,DATEADD(mm, DATEDIFF(m,0,GETDATE()),0))

----Last Day of Current Month
SELECT DATEADD(s,-1,DATEADD(mm, DATEDIFF(m,0,GETDATE())+1,0))

----Last Day of Next MonthSELECT DATEADD(s,-1,DATEADD(mm, DATEDIFF(m,0,GETDATE())+2,0))

ResultSet:

LastDay_PreviousMonth

———————–

2007-07-31 23:59:59.000

LastDay_CurrentMonth

———————–

2007-08-31 23:59:59.000

LastDay_NextMonth

———————–

2007-09-30 23:59:59.000

----------------------------------------------------------------------------------------------------------------------

--Last Day of Any Month and YearDECLARE @dtDate DATETIMESET @dtDate = '8/18/2007'SELECT DATEADD(s,-1,DATEADD(mm, DATEDIFF(m,0,@dtDate)+1,0))LastDay_AnyMonth

ResultSet:

LastDay_AnyMonth

———————–

2007-08-31 23:59:59.000