[Tanya] Bagaimana mengatur format datetime pada Sql Server? : SQL Server

[Tanya] Bagaimana mengatur format datetime pada Sql Server?

Moderator: trail

3 posts • Page 1 of 1

[Tanya] Bagaimana mengatur format datetime pada Sql Server?

by jagad » 08 Feb 2012, 08:23

pagi..
kan format default datetime ("mm/dd/yyyy"). Bagaimana caranya kalo mw mengubah jadi ("dd/mm/yyyy")?

jagad: Prajurit Dua; Posts: 20; Joined: 07 Feb 2012, 14:43; Memberi kopi: 2 cangkir; Mendapat kopi: 0 cangkir

Re: [Tanya] Bagaimana mengatur format datetime pada Sql Serv

by trail » 08 Feb 2012, 08:29

Code: Select all: SELECT CONVERT(VARCHAR(10), Tanggal, 103) AS [Tanggal] FROM Table

@_@....@_@....@_@

Database Moderator

Database Moderator

Posts: 1348

Joined: 11 Mar 2010, 14:27

Location: Surabaya

Memberi kopi: 47 cangkir

Mendapat kopi: 103 cangkir

YIM

Re: [Tanya] Bagaimana mengatur format datetime pada Sql Serv

by jagad » 18 Feb 2012, 23:01

trail wrote:
Code: Select all
SELECT CONVERT(VARCHAR(10), Tanggal, 103) AS [Tanggal] FROM Table

sory om, br bls.. ok, thx om

~o)

jagad: Prajurit Dua; Posts: 20; Joined: 07 Feb 2012, 14:43; Memberi kopi: 2 cangkir; Mendapat kopi: 0 cangkir

3 posts • Page 1 of 1

Return to SQL Server

Jump to:

Who is online

Users browsing this forum: No registered users and 2 guests