title: Format Date Number from Database
body: <p>Not sure if I should edit this question or just ask another question in a different post. I am having a hard time doing the reverse of what I originally asked. How do I get the "date number" in php. I want to assign the current date number to a variable to so I can use it in my query to compare what is already in the database.</p>
  
  <blockquote>
    <p>I can not see the SQL Server database
    but I am connecting to it using ODBC
    and PHP on a Linux box. I was told
    that the field "meeting_start" was a
    "Date Number". When I get the value of
    the "meeting_start" the format looks
    like this.</p>
  
  <pre><code>2010-08-24 20:00:00.000 
  </code></pre>
    
    <p>I need both the date and time but for
    different parts of my function.  Is
    there a way to extract the data for
    the date and save to a variable and
    then extract the data for the time and
    save to a different variable. Below is
    me trying to take a stab at it.</p>
  
  <pre><code>$time_date_data = "2010-08-24 20:00:00.000"
  
  $meeting_date = get_date($time_date_data); 
  
  $meeting_time = get_time($time_date_data);
  </code></pre>
  </blockquote>