Then were is the solution to my Data retrieval problem! :)
--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
quot; <[EMAIL PROTECTED]>
Sent: Tuesday, March 23, 2004 3:10 PM
Subject: RE: [PHP-WIN] Convert string to date
> With MS SQL server you can do something like this:
>
> select convert(char(10), expiration, 101) as
> ...
> order by convert(varchar, expiration, 112)
>
&
There are date functions that should allow you to manipulate and work with
date's and their corresponding attributes. Check them out.
For example, if you pass a date as a parameter to the 'mktime()' function you
will get returned an integer value that represents the amount of seconds
passed sin
With MS SQL server you can do something like this:
select convert(char(10), expiration, 101) as
...
order by convert(varchar, expiration, 112)
112 gives the date format as "mmdd", and that should
solve your problem.
-Original Message-
From: Harpreet K. Singh
To: 'Php-Windows '
Sen
