Returning formated date

Don Grover

Hi
I have to return dates formated in different ways in an asp page from sql
server.
What function can I use or how can I return dates formated like so

I tried DATEPART ie.. but that does not work they way I would expect

"dd/mm/yy"
"dd/mm/ccyy"
"mm/dd/ccyy"
"mm/dd/yy"
"dd mmm ccyy"
"ccyymmdd"

Regards
Nancy

Jul 19 '05 #1

Subscribe Post Reply

2196

Roji. P. Thomas

Look at the
convert function in Bol
--
Roji. P. Thomas
SQL Server Programmer ;)
________________________
"Don Grover" <sp******@assoft.com.au> wrote in message
news:O$**************@TK2MSFTNGP12.phx.gbl...

Hi
I have to return dates formated in different ways in an asp page from sql
server.
What function can I use or how can I return dates formated like so

I tried DATEPART ie.. but that does not work they way I would expect

"dd/mm/yy"
"dd/mm/ccyy"
"mm/dd/ccyy"
"mm/dd/yy"
"dd mmm ccyy"
"ccyymmdd"

Regards
Nancy

Jul 19 '05 #2

Dan Guzman

To add to Roji's response, consider formatting dates in your application
code. Formatting data for presentation is usually best handled in client
code.

--
Hope this helps.

Dan Guzman
SQL Server MVP
"Don Grover" <sp******@assoft.com.au> wrote in message
news:O$**************@TK2MSFTNGP12.phx.gbl...

Hi
I have to return dates formated in different ways in an asp page from sql
server.
What function can I use or how can I return dates formated like so

I tried DATEPART ie.. but that does not work they way I would expect

"dd/mm/yy"
"dd/mm/ccyy"
"mm/dd/ccyy"
"mm/dd/yy"
"dd mmm ccyy"
"ccyymmdd"

Regards
Nancy

Jul 19 '05 #3

Don Grover

Thanks all working now, had to format in code and add correct headers , now
work well.
Thanks Guys

"Dan Guzman" <da*******@nospam-earthlink.net> wrote in message
news:OZ**************@tk2msftngp13.phx.gbl...

To add to Roji's response, consider formatting dates in your application
code. Formatting data for presentation is usually best handled in client
code.

--
Hope this helps.

Dan Guzman
SQL Server MVP
"Don Grover" <sp******@assoft.com.au> wrote in message
news:O$**************@TK2MSFTNGP12.phx.gbl...
Hi
I have to return dates formated in different ways in an asp page from sql server.
What function can I use or how can I return dates formated like so

I tried DATEPART ie.. but that does not work they way I would expect

"dd/mm/yy"
"dd/mm/ccyy"
"mm/dd/ccyy"
"mm/dd/yy"
"dd mmm ccyy"
"ccyymmdd"

Regards
Nancy

Jul 19 '05 #4

by: Funnyweb | last post by:

I have just notices that the date() function is not returning the correct date/time on my "server". I am running apache2 on my winxp pro laptop. My system clock is set to the correct date,...

PHP

Returning Variant data from Java to PL/SQL & SQL?

by: Nick Thurn | last post by:

Folks, I'm trying to define a oracle Java Stored Proc interface to an existing timeseries database. Series are accessed by name and are returned as vectors of type pairs, specifically (Date,...

Oracle Database

HttpBrowserCapabilities not returning correct netscape version

by: Earl T | last post by:

When I try to get the netscape version for version 7, I get the HttpBrowserCapabilities class returning the version as 5 and not 7. (see code and output below) CODE HttpBrowserCapabilities...

ASP.NET

Read Formated Text From MS Word

by: sb Luis | last post by:

I Use the following code to read from MS Word, but I couldent read Formated Text (RTF). How Can I read formated text from MS Word Doc without using clipboard. thanks. Word.ApplicationClass...

C# / C Sharp

Converting int seconds to datetime or formated string

by: Pat Brown | last post by:

I am pulling an integer value of the amount of seconds since 12:00 am from a SQL Server DB. I want to convert this integer into a formated string or datetime to display a legible time of day. Are...

C# / C Sharp

Question about returning a smalldatetime from a Function

by: SQL Server | last post by:

I've been working this for a while. Kind of new to SQL Server functions and not seeing what I am doing wrong. I have this function CREATE FUNCTION dbo.test (@Group varchar(50)) RETURNS...

Microsoft SQL Server

Put today's date into a MySQL "date" formated field

by: walterbyrd | last post by:

My MySQL table has a field that is set as type "date." I need to get today's date, and insert it into that field. The default for that MySQL field is 2006-00-00. I know about the date()...

PHP

Microsoft Word VBA Returning the Position of a line

by: iheartvba | last post by:

Hi, I have got a document where there are headings which are always the same, but their sub categories are always different. The Structure is as follows: Line 1: Heading 1 Line 2: Sub Heading...

Visual Basic 4 / 5 / 6

Filtering Access Reports Based on Formated a Date

by: zandiT | last post by:

Hello I have an access report and im using a query to filter the report using Date parameters eg Start Date-12 May 2009 and End Date-30 September 2009. the query works perfectly. My problem is...

Microsoft Access / VBA

Basic Javascript concepts

by: aa123db | last post by:

Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...

Javascript

Merging data from multiple Excel files

by: ryjfgjl | last post by:

In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...

Data Management

Migrating Website to Cloud - Emmanuel Katto

by: emmanuelkatto | last post by:

Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel

General

Navigating the Data Structures and Algorithms (DSA)

by: BarryA | last post by:

What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...

Algorithms / Advanced Math

Looking to do Android software development, any suggestions? Is flutter better?

by: nemocccc | last post by:

hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?

General

Is that possible of reading the .csv file in column wise and the column have different lengths ?

by: Sonnysonu | last post by:

This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

C / C++

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...

General

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...

Windows Server

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

C / C++

Similar topics