How to order by date inselect statement using Microsoft SQL query

SMS enable your application via Clickatell’s fast, simple and reliable API's, built to integrate with any system. Click here to learn more.

Flash Website Builder- Trendy Site Builder is a Flash Site Building tool that helps users build stunning websites.

Check Out Custom Custom Logo Design by LogoBee. Website Design and Free Logo Templates available.

		CodingForums.com > :: Server side development > MySQL
How to order by date inselect statement using Microsoft SQL query

Before you post, read our: Rules & Posting Guidelines

Enjoy an ad free experience by logging in. Not a member yet? Register.

06-27-2002, 08:59 AM	PM User \| #1
therry New Coder Join Date: Jun 2002 Posts: 15 Thanks: 0 Thanked 0 Times in 0 Posts	How to order by date inselect statement using Microsoft SQL query Hi, I would like to do a SELECT query statement from a table and would like to order the records based on date field in the table. How can I do it using Microsoft SQL? For example: Select * from MMPODT order by keyval3(date's field name) The date field's data type is character and it is displayed as 20020625 (yyyymmdd)

Bookmarks

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Forum Rules

Forum Jump

All times are GMT +1. The time now is 02:24 AM.