GeekArticles 
XML RSSTransact-SQL RFC822 DateTime UDF
Author: eggheadcafe.com |
Published: 10th Aug 2005 |
Visited: 1064 times |
Add CommentFiled in: RSSPrinter Friendly Version Have you ever wanted to generate RSS from a Stored procedure? It's easy, until you get to the RFC822 date requirement! Believe it or not, I could not find this anywhere-- I actually had to cobble it together from pieces myself. Enjoy: IF OBJECT_ID('[dbo].[fnRFC822Date]', 'FN') IS NOT NULL DROP FUNCTION [dbo].[fnRFC822Date] GO CREATE FUNCTION [dbo].[fnRFC822Date] ( @Date datetime ) RETURNS nvarchar(70) AS BEGIN DECLARE @display nvarchar(70) SET @display =...n
Read Article Sponsored Links
Related Articles
• Incorrect datetime stamp on some feeds on welcome page QC#: 47071 Version: 11.0 Status: Open defect, requires resolution Description: Just a silly thing:
When using Select Newsfeed -> Codegear Developer Network -> Delphi from the welcome screen, all date stamps below the article summaries are exactly one ...
• Excel 2007 Week Numbering Systems and DateTime Implementations Learn about the four different week-numbering systems available in Microsoft Office Excel and how to use them. Also learn why it is important to implement the date and time representation of the ISO8601:2000 standard in your Excel applicatio ...
• Persian DateTime A structure like System.DateTime which is designed to support Persian cale ...
