Web Wiz - Green Windows Web Hosting
Web Wiz Homepage Search Web Wiz

  New Posts New Posts RSS Feed - Problem with dates
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

Problem with dates
 Post Reply Post Reply Page  <12
Author
  Topic Search Topic Search  Topic Options Topic Options
Paul Lush View Drop Down
Mod Builder Group
Mod Builder Group


Joined: 24 September 2003
Status: Offline
Points: 59 		Post Options Post Options   Thanks (0) Thanks(0)   Quote Paul Lush Quote  Post ReplyReply Direct Link To This Post Posted: 09 December 2003 at 4:40am

As I dont have mySQL installed, have a look at

http://www.mysql.com/doc/en/Date_and_time_functions.html
Back to Top
zaboss View Drop Down
Senior Member
Senior Member


Joined: 20 August 2002
Location: Romania
Status: Offline
Points: 454 		Post Options Post Options   Thanks (0) Thanks(0)   Quote zaboss Quote  Post ReplyReply Direct Link To This Post Posted: 09 December 2003 at 5:13am
Well, none of the manual suggestions works for ASP.
Cristian Banu
Soft 4 web
Back to Top
zaboss View Drop Down
Senior Member
Senior Member


Joined: 20 August 2002
Location: Romania
Status: Offline
Points: 454 		Post Options Post Options   Thanks (0) Thanks(0)   Quote zaboss Quote  Post ReplyReply Direct Link To This Post Posted: 09 December 2003 at 9:21am

Finaly sorted out. It should be:

<% data =  DatePart("yyyy", Date) &"-"& DatePart("m", Date) &"-"&DatePart("d", Date) %>
Set RS1 = MyConn.execute("Select NumeFirma, Pozitia, DataExpirarii, DataIntroducerii, ID From Oferte  where DataExpirarii > '"& data &"' Order By DataIntroducerii DESC Limit 10")
Cristian Banu
Soft 4 web
Back to Top
 Post Reply Post Reply Page  <12

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 12.08
Copyright ©2001-2026 Web Wiz Ltd.

Become a Fan on Facebook Follow us on X Connect with us on LinkedIn Web Wiz Blogs
About Web Wiz | Contact Web Wiz | Terms & Conditions | Cookies | Privacy Notice

Web Wiz is the trading name of Web Wiz Ltd. Company registration No. 05977755. Registered in England and Wales.
Registered office: Web Wiz Ltd, Unit 18, The Glenmore Centre, Fancy Road, Poole, Dorset, BH12 4FB, UK.

Prices exclude VAT at 20% unless otherwise stated. VAT No. GB988999105 - $, € prices shown as a guideline only.

Copyright ©2001-2026 Web Wiz Ltd. All rights reserved.