selectiing a month out of a date

2003-08-28 Thread Creative Solutions New Media
Hi, I have a table with a date field (called myDate for example) formatted like -xx-xx. I want to do a query searching for all dates with the month of August, for example. How would I do that? Tim Winters Manager, Creative Development Sampling Technologies Incorporated (STI) [EMAIL

RE: Newbie SELECT problem

2003-07-02 Thread Creative Solutions New Media
Hello Peter, I agree I don't seem to be explaining what I want properly. Let me offer some data: (hopefully this will come out ok in the message). hitID sessionID userID timedatepageName 251 2917000 3591528 6:22:17 2003-7-2News Section 250 2917000 3591528

NEWBIE QUESTION: Copying Databases from local to server

2003-06-04 Thread Creative Solutions New Media
Hello, I have several databases currently located on my local machine that I need to copy to a remote server. Con someone explain the process and details of how this is done? Thanks, Tim Winters Manager, Creative Development Sampling Technologies Incorporated (STI) [EMAIL PROTECTED] [EMAIL