Menambah dan Mengurangi Datetime di SQL SERVER / MYSQL | DATEADD | DATEDIFF


Cara Menambahkan tanggal dengan int  yaitu menggunakan fungsi DATEADD, dengan format sebagai  berikut :
select DATEADD("dd", @jumlah , @DATE) --> hasil :
 contoh :

select DATEADD("dd", 2 , 2012-03-21) --> hasil : 2012-03-23
 Menambahkan atau mengurangi tanggal dengan tanggal. menggunakan fungsi DATEDIFF, formatnya yaitu :

select DATEDIFF("dd",'01-01-2011','02-01-2011'); --> Hasil : adalah 31 select DATEDIFF("dd",'03/01/2011','02/01/2011'); --> Hasil : adalah -28

Comments

Post a Comment

Popular posts from this blog

Create Calculator With Visual Studio 2012 | VB.Net Calculator

Image
picture : if text field is null How to create Simple Calculator with visual studio 2012 or VB.Net? This is your solution, you can read this tutorial, you also can Download Source Code Simple Calculator with visual studio 2012 , and direct practice this tutorial. Open Visual Studio, New Project  then, create design like this picture : 3. Right Click or F7 to view Source Code, 4. Write code like this : Public Class Calculator Private Sub Button1_Click(sender As Object, e As EventArgs) Handles Button1.Click Dim A = varA.Text Dim B = varB.Text If (A = "") Then warn.Text = "var A Not Allow null" ElseIf (B = "") Then warn.Text = "var B Not Allow null" Else Dim c = A * B Operation.Text = "X" Result.Text = c End If End Sub Private Sub ExitToolStripMenuItem_Click(sender As Object, e As...
Read more

PHP with MySQL-Create mysql connection in php

To connect php with mysql, we need a code to connect. follow the tutorial below: create a file "connect.php" edit script: <?php $host="server"; $user = "username"; $pass = "password"; $dbname = "dbname"; $conn = mysql_connect ($host, $user, $pass); if ($conn) { $conect = mysql_select_db ($dbname); if (!$conect) { die ("can't open database!"); } } else { die ("Can't connect to server"); } ?> save and run. success. thank you for this blog visit home kitprogrammer
Read more