DTP


 
Lively discussions on the graphic arts and publishing — in print or on the web


Go Back   Desktop Publishing Forum > General Discussions > Web Site Building & Maintenance

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
Old 02-15-2006, 04:08 PM   #1
BinkyM
Member
 
BinkyM's Avatar
 
Join Date: Jan 2005
Location: New York, NY
Posts: 32
Default Date handling query in SQL

Folks:

I've inherited a SQL database in which a date is kept in a datetime-type field. I have no idea how to do a query on it. My first (and only) thought was to try:

Code:
select user_name from AHmembers where signup_date > "2006-02-13 23:59:59"
but that didn't work. I can't find anything in the MySQL 5.0 documentation that tells me how to accomplish what it is I'm looking to do. I'd be way grateful for a pointer!

   
__________________
Bink of Snarkish, intelligent discussion forums for adults with their clothes on
BinkyM is offline   Reply With Quote
 

Thread Tools
Display Modes

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 Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Getting a good date Richard Waller The Corner Pub 6 08-23-2006 07:13 AM
PowerPoint query klare Print Design 9 04-17-2005 07:02 PM


All times are GMT -8. The time now is 10:16 PM.


Powered by vBulletin® Version 3.8.9
Copyright ©2000 - 2023, vBulletin Solutions, Inc.
Contents copyright 2004–2019 Desktop Publishing Forum and its members.