Re: Format() Function in MS SQL
- From: Erland Sommarskog <esquel@xxxxxxxxxxxxx>
- Date: Mon, 28 Nov 2005 22:44:50 +0000 (UTC)
sql guy123 (stoppal@xxxxxxxxxxx) writes:
> I'm pretty new to MS SQL,
>
> My problem is setting ....
>
>=Format$(Date(),"mm" & "/1/" & "YYYY")
>
> (Which is from my MS ACCESS database)
>
> as my default value in MS SQL. How can I do this since format() does
> not seem to be a function that is in MS SQL. The above function works
> great in MS ACCESS, but not in MS SQL.
There are *huge* differences between Access and SQL Server. First of all
SQL Server is a server-only program, while in Access, you have a mixup
of client and database in the same package. But there are also big
differences between Access and SQL Server in the SQL dialect.
For formating dates, you use the convert function:
SELECT convert(varchar, getdate(), nnn)
where nnn is a format code, each format code giving a different format. And
there is no room for customer format. Look up the topic CAST and CONVERT in
Books Online to see the available format codes.
Best practice, though, is to return dates as is from SQL Server, and do
the formatting in the client, so the user's regional settings can be
taken into account.
--
Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
.
- Follow-Ups:
- Re: Format() Function in MS SQL
- From: sql guy123
- Re: Format() Function in MS SQL
- References:
- Format() Function in MS SQL
- From: sql guy123
- Format() Function in MS SQL
- Prev by Date: Re: CASE problem
- Next by Date: Re: Select into / Linked Server / Missing IDENTITY attribute
- Previous by thread: Format() Function in MS SQL
- Next by thread: Re: Format() Function in MS SQL
- Index(es):
Relevant Pages
|
