Return formatted datetime as a string

By philcart, 2002/02/27

Total article views: 601 | Views in the last 30 days: 2

Rate this |

Join the discussion |

Briefcase

Pass a datetime value and receive back a formatted string. Much like the Format$ function in Visual Basic.

I put this together to provide a date string to add to filename. Also handy when you are creating text files that require datetime data to be output in weird character formats like yyddmm or yyyymm.

eg: fnDate2Char(GetDate(), 'dmy', 1, 1) will return 26022002 for the 26th Feb 2002.

By philcart, 2002/02/27

Total article views: 601 | Views in the last 30 days: 2

Your response

Rate this |

Join the discussion |

Briefcase

Related tags

Script to Search SQL Error Log For a String

By pochinej | Category: Miscellaneous

| 1,098 reads

Script to Attach Multiple MDF

By Andy Warren | Category: Miscellaneous

| 953 reads

Find strings in a stored procedure

By jraha | Category: Miscellaneous

| 1,448 reads

Convert Hex value to Signed 32-bit int

By oferb@mail.com | Category: Miscellaneous

| 999 reads

Like this? Try these...

Simple function to return time from datetime value

By Neil Jacobson | Category: Miscellaneous

| 647 reads

sp_MSforeachsproc -Perform an action on each sproc

By Brian Knight | Category: T-SQL Aids

| 1,167 reads

Simple Function For Number To Word

By patel_mayur

| 22 reads

Already registered?

Free registration required

To read the rest of this article, and access thousands of other articles, we ask you to register on the site and subscribe to our newsletters.

Register

E-mail address:
Password:
Password (confirm):

Subscriptions

We ask you to register on the site and subscribe to our newsletters. Subscribing to our newsletters gets you:

ALL of our content (thousands of articles, scripts, and forum postings)
A daily newsletter (example)
A weekly news round up (example)
The opportunity to ask and answer questions in our forums
A daily Question of the Day to test and help you increase your knowledge of SQL Server.

We ask that you give the newsletter a try for a week. Over 200,000 SQL Server Professionals a day find it entertaining and useful. If not, you are welcome to unsubscribe at anytime.

Steve Jones
Editor, SQLServerCentral.com