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.....
ankit.pandey3
-8
Junior Poster in Training
Recommended Answers
Jump to Post<?php $date = '140811 060632'; echo DateTime::createFromFormat('dmy his', $date)->format('Y-m-d H:i:s');
All 2 Replies
cereal
1,524
Nearly a Senior Poster
Featured Poster
mschroeder
251
Bestower of Knowledge
Team Colleague
cereal
commented:
nice! :)
+6
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.