SitePoint Sponsor

User Tag List

Results 1 to 5 of 5

Hybrid View

  1. #1
    SitePoint Enthusiast
    Join Date
    Nov 2010
    Posts
    93
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    How to convert string into datetime stamp in php

    PHP Code:
    <?php
    $myServer 
    "202.138.125.155";
    $myUser "micro_fms";
    $myPass "micro_fms*#$";
    $myDB "micro_fms"

    //create an instance of the  ADO connection object
    $conn = new COM("ADODB.Connection")or die("Cannot start ADO");

    //define connection string, specify database driver
    $connStr "PROVIDER='SQLOLEDB'; SERVER=".$myServer.";UID=".$myUser.";PWD=".$myPass.";DATABASE=".$myDB

    //Open the connection to the database
    $conn->open($connStr);

    //$table_name=$_GET['Device'];
    $table_data=$_GET['Data'];
    $data=(explode(",",$table_data));

    $table_name=$data[0];
    $speed=$data[1];
    $time=$data[2];
    $date=$data[3];
    $lat=$data[4];
    $long=$data[5];
    //$newdate = substr($date,6,2) . "-" . substr($date,0,2) . "-" substr($date,3,2);
    $datetime=$date.$time;


    $new_lat substr($lat,0,2).'.'.substr($lat,2);
    $new_long substr($long,0,2).'.'.substr($long,2);

    echo 
    $table_name."<br>";
    echo 
    $speed."<br>";
    echo 
    $new_lat."<br>";
    echo 
    $new_long."<br>";
    echo 
    $datetime."<br>";

    $query="insert into $table_name (DeviceNumber,Speed,dtDateTime,Latitude,Longitude)values('$table_name','$speed','$datetime','$new_lat','$new_long')";


    //execute the SQL statement and return records
    $rs $conn->execute($query);
    if(
    $rs)
    {
    echo 
    'Values Inserted';
    }
    else
    {
    echo 
    "faile";
    }
    ?>
    Hi friends...
    I have two variables ($date and $time). I concat these two strings and make a new variable called "$datetime". Now in above code I want to insert it into table but I got the following error.
    Code:
    Fatal error: Uncaught exception 'com_exception' with message '<b>Source:</b> Microsoft OLE DB Provider for SQL Server<br/><b>Description:</b> Conversion failed when converting datetime from character string.' in C:\wamp\www\FMS\fms.php:44 Stack trace: #0 C:\wamp\www\FMS\fms.php(44): com->execute('insert into A00...') #1 {main} thrown in C:\wamp\www\FMS\fms.php on line 44
    In my database, data type of column in which I want to insert is Date time stamp though I have string type ($datetime) variable.
    I think I have to convert this $datetime variable string to "DateTime type first but don't have any idea about it.
    Please help??/
    Thanks in advance....

  2. #2
    SitePoint Member
    Join Date
    Oct 2009
    Posts
    21
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Try...

    $datetime = date('required format here', strtotime($datetime));

    Check php.net/date for how to format the date how you want it. MySQL for example uses 'Y-m-d H:i:s' for the format.

  3. #3
    SitePoint Enthusiast
    Join Date
    Nov 2010
    Posts
    93
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Thanks for your reply..
    This $datetime can't insert in database and throw out of range error.
    I have a one more requirement also.
    Now, I want in $time variable add 5:30:00 and store in time format( so that it can be insert it in database) and I have date in ddmmyy format but in string type which i have to convert it in date mm-dd-yyformat ( again so that it can be insert it in database).
    How can I do these???

  4. #4
    SitePoint Member
    Join Date
    Oct 2009
    Posts
    21
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Post the error and the code (now that it's changed) that generated it and I'll have a look in a bit more detail.

    If you're wanting to modify time stamps rather than simply format it for inserting into a database you might want to take a look at http://www.php.net/manual/en/class.datetime.php

  5. #5
    SitePoint Enthusiast
    Join Date
    Nov 2010
    Posts
    93
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Hi friends...
    I have a variable $datetime= 140811 060632.
    Here 140811 represents date in ddmmyy format and 060632 represents time 06:06:32 and both are in string type.
    I have a column name "DtTime" in MSSQL of type "Datetime" stamp.
    Now when i try to insert my variable $datetime in above column of database it returns an "out of memory" error which means I think I have to convert my string to "datetime" stamp type first and then try to insert.
    I don't know how I can convert string to datetime type so that it inserts in column of "datetime" stamp type.
    Please help...
    Thanks in advance...


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •