ASP - MSSQL date format problem

dwair · #1 (**permalink**) Nov 22nd, 2005, 21:17

Hi
I’m new to MS-SQL and I’m having a problem with an ASP3 JS website that I’m upgrading from Access. I’m trying to format the date from mm/dd/yyyy as held in the db by GETDATE to display as dd/mm/yyyy on a web page.

Previously with the Access db I used -
"SELECT format(addate, 'dd/mm/yyyy') as addate1 FROM...”

What do you use with MS-SQL???

Any help greatly appreciated as this is driving me nuts!!!

Smokie · #2 (**permalink**) Nov 23rd, 2005, 07:57

Code: Select all

CAST()

You'll have to search on google for examples of how to use it cause its been so long i cant remember!

avalon · #3 (**permalink**) Nov 23rd, 2005, 13:21

If you wanted to format the date through ASP you can do that using the 'Format' function. However just like above I cannot remember the exact syntax so google is your best bet for that.

Tim
Web Design

Smokie · #4 (**permalink**) Nov 24th, 2005, 12:26

Quote:

Originally Posted by avalon

If you wanted to format the date through ASP you can do that using the 'Format' function. However just like above I cannot remember the exact syntax so google is your best bet for that.

Tim
Web Design

Code: Select all

FormatDateTime()

u2orange · #5 (**permalink**) Nov 29th, 2005, 12:56

you could try adding to the first line of your query:

SET DATEFORMAT DMY;

This will force the date as dd/mm/yyyy

Might be of help!

#6 (**permalink**) Nov 29th, 2005, 23:15

select convert(varchar(10), addate, 103) as 'addate1' from....

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
JS date format	joe3dge	JavaScript Forum	0	May 21st, 2007 00:11
Changing date format in date picker	AdRock	JavaScript Forum	1	Aug 1st, 2006 17:16
Date/Time format & multiple selection with listbox problem	frmsasp	ASP.NET Forum	0	Oct 12th, 2005 10:29
date format help please	charter	Databases	3	Jun 14th, 2004 20:09
Date Format	ekendricks	Classic ASP	3	Sep 1st, 2003 17:03

		Webforumz.com > Main Forums > Program Your Website > Classic ASP
ASP - MSSQL date format problem