Login
Latest Code Ticker for SQL.
Daily Code Email
|
|
| |
|
| 
| Submitted on: 11/7/2002 7:50:12 AM
By: Tom A. Holder
Level: Beginner
User Rating:
By 1 Users
Compatibility:SQL Server 2000, SQL Server 7.0
Users have accessed this code 2183 times.
| |
| | | A very simple function I wrote for a multi-lingual web site to output all dates in ISO format YYYY-MM-DD. This function can be used inline.
E.g.
SELECT Name, dbo.DateToIso(SignUpDate) as SignUpDate
FROM Users
| | | |
Can't Copy and Paste this?
Click here for a copy-and-paste friendly version of this code!
|
--**************************************
--
-- for :DateToIso
--**************************************
--
USE AS you will AND enjoy. | code:
Can't Copy and Paste this?
Click here for a copy-and-paste friendly version of this code!
Terms of Agreement:
By using this code, you agree to the following terms...
1) You may use
this code in your own programs (and may compile it into a program and distribute it in compiled format for languages that allow it) freely and with no charge.
2) You MAY NOT redistribute this code (for example to a web site) without written permission from the original author. Failure to do so is a violation of copyright laws.
3) You may link to this code from another website, but ONLY if it is not wrapped in a frame.
4) You will abide by any additional copyright restrictions which the author may have placed in the code or code's description. |
--**************************************
--
-- Name: DateToIso
-- Description:A very simple function I
-- wrote for a multi-lingual web site to ou
-- tput all dates in ISO format YYYY-MM-DD.
-- This function can be used inline.
E.g.
SELECT Name, dbo.DateToIso(SignUpDate) AS SignUpDate
FROM Users
-- By: Tom A. Holder
--
-- Inputs:Take a date/time variable.
--
-- Returns:varchar
--
--This code is copyrighted and has-- limited warranties.Please see http://
-- www.Planet-Source-Code.com/vb/scripts/Sh
-- owCode.asp?txtCodeId=586&lngWId;=5--for details.--**************************************
--
/*===============================================================
DateToIso
----------------------------------------
-----------------------
Purpose : Returns a date formatted AS YYYY-MM-DD
Author : Tom Holder
Note: Other possible formatting codes.
0 OR 100 (*) DEFAULT mon dd yyyy hh:miAM (or PM)
1 101 USA mm/dd/yy
2 102 ANSI yy.mm.dd
3 103 British/French dd/mm/yy
4 104 German dd.mm.yy
5 105 Italian dd-mm-yy
6 106 - dd mon yy
7 107 - mon dd, yy
8 108 - hh:mm:ss
- 9 OR 109 (*) DEFAULT + milliseconds mon dd yyyy hh:mi:ss:mmmAM (or PM)
10 110 USA mm-dd-yy
11 111 JAPAN yy/mm/dd
12 112 ISO yymmdd
- 13 OR 113 (*) Europe DEFAULT + milliseconds dd mon yyyy hh:mm:ss:mmm(24h)
14 114 - hh:mi:ss:mmm(24h)
- 20 OR 120 (*) ODBC canonical yyyy-mm-dd hh:mi:ss(24h)
- 21 OR 121 (*) ODBC canonical (with milliseconds) yyyy-mm-dd hh:mi:ss.mmm(24h)
----------------------------------------
-----------------------
Parameters
-----------
IN: DateForConversion - The date TO CONVERT to ISO format.
----------------------------------------
-----------------------
Returns : Recordset OF USER GROUP access.
----------------------------------------
-----------------------
Revision History
----------------------------------------
-----------------------
--21/10/02 - TH - Original SPROC coded
===============================================================*/
CREATE FUNCTION dbo.DateToIso
(
@DateForConversion datetime
)
RETURNS varchar(10)
AS
BEGIN
DECLARE @IsoDate varchar(8)
SET @IsoDate = CONVERT(varchar(8),@DateForConversion,112)
RETURN SUBSTRING(@IsoDate , 1 , 4) + '-' + SUBSTRING(@IsoDate, 5,2) + '-' + SUBSTRING(@IsoDate, 7, 2)
END | | | | | Report Bad Submission | | | | | Your Vote! | |
See Voting Log | | | | Other User Comments | 9/3/2003 6:02:10 AM:
hi,i think it would be very useful for
me,but i am afraid that i don't know
how to use it exactly in the middle of
my sql guery!!
| | | Add Your Feedback! | Note:Not only will your feedback be posted, but an email will be sent to the code's author in your name.
NOTICE: The author of this code has been kind enough to share it with you. If you have a criticism, please state it politely or it will be deleted.
For feedback not related to this particular code, please click here.
| |
|
|
