ive got a MSSQL date / time format like:
Oct 24 2006 12:00AM
im trying to change it so it displays like:
24/Oct/2006 using the mktime() but im getting:
Warning: mktime() expects parameter 4 to be long, string given in c:\Inetpub\wwwroot\preleas
01/Jan/1970
My code:
echo date('d/M/Y',mktime(0,0,0,
This Question has been solved and asker verified All Experts Exchange premium technology solutions are available to subscription members.
Experts Exchange has been collecting answers to technology questions since 1996…3 million and counting! If you have a question, chances are we already have your answer.
If you can't find the exact answer you're looking for, ask our exclusive community of 50,000 experts. You’ll get a personalized answer from a trusted professional.
Thousands of free tech tips, tricks, how-to’s and tutorials are available in our peer reviewed articles section. See for yourself how smart our experts are, no login required.
Save solutions to your questions, answers you’ve discovered through searching plus helpful articles in your personal knowledgebase for easy future access.
Access the answers to your technology questions today.
30-day free trial. Register in 60 seconds.
Members of the expert community talk about why the experience at Experts Exchange is different than what you will find anywhere else.
Try it out and discover for yourself.
30-day free trial. Register in 60 seconds.
Join the community of experts here and help other tech pros by answering question in your area of expertise. You can earn FREE access to all Experts Exchange's premium features and resources.
You could try working with strtotime, but I doubt it will accept that date format. strptime should when your locale is set on english
Try:
$array = strptime($date, '%b %e %Y %H:%M%r'); //(when using Oct 1 2006)
or
$array = strptime($date, '%b %d %Y %H:%M%r'); //(when using Oct 01 2006)
$stamp = mktime($array['tm_hour'], $array['tm_min'], $array['tm_sec'], $array['tm_mon'], $array['tm_mday'], $array['tm_year']);
echo date('d/M/Y/, $stamp);
-r-
I would recommend against changing your timestamp field. Keep it in your database and update the time by using update tablename set mydatefield = NOW() where myotherfield = y;
When formatting the string, the database has very powerful formatting capabilities. The sql I would use for the above would look like:
select date_format(mydatefield, '%b %d %Y %h:%i%p') as formatteddate from tablename where myotherfield = 'foo'; and that would give you an output of Oct 24 2006 12:00AM. There are many other formatting parameters that you can give the date_format function.
I find it is best to use the database whereever possible to do date and time formats, along with date and time calculations. This then frees up php to actually process the other data.
>>I would recommend against changing your timestamp field. Keep it in your database and update the time by using update tablename set mydatefield = NOW() where myotherfield = y;
do you want my Senior Programmer to kill me. Our database is used by a large number of people and other web applications so changing it will cause more problems that good so your answer is no.
AngelIII
when i try using convert() i get this:
Warning: mssql_result() [function.mssql-result]: DateIn field not found in result in c:\Inetpub\wwwroot\preleas
My query:
$query = "SELECT CONVERT(varchar(40),DateIn
Ellandrd, by running the convert you are changing your datetime field to a varchar with a length of 40. If your Senior Programmer is going to kill you, then I suggest you start running immediately because he's after you...Lol.
By running the date_format() code as provided, you will find that your formatting of the information will come out nicely. I must clearly state though that by running the date_format function, you will not change any data in the database, you are merely changing the way it's outputted at runtime. For example:
select date_format(mydatefield, '%b %d %Y %h:%i%p') as formatteddate from tablename where myotherfield = 'foo';
and select date_format(mydatefield, '%M %d %Y %H:%i:%s') as formatteddate from tablename where myotherfield = 'foo'
will return two seperate formats of the date, but the data in the data will remain unchanged.
I would never provide code that would change the integrity of your data...just the way it looks when you output it.
Hope this helps.
Ok ive managed to kinda workaround it using explode(). its probably not the best or most efficient way but none of the solution/ functions provided seem to work.
my "workaround" is as follows:
$parts = explode(' ',$datein);
echo $parts[1].'/'.$parts[0].'/
Thanks to everyone who took some time to help me...
ellandrd
p.s the accepted comment was not given to any particular expert for any reason, i just selected the first reply as i have to select an accepted comment as we all know... points split.
oh yes, im sure it will. the functions and advice i got today will be referred back to when i have more issues.
i alway take on board any help i get from EE experts so next time i dont have to ask a question - instead start answering more of them for others! its a great learning curve - hey? ;-)
ellandrd
Business Accounts
Answer for Membership
by: angelIIIPosted on 2006-10-25 at 02:01:11ID: 17801789
>ive got a MSSQL date / time format like:
>Oct 24 2006 12:00AM
do you actually have a datetime field or a varchar field?
on a datetime field, use the convert in the query itself:
select convert(varchar(40), yourfield, 106) from yourtable
resp:
select replace(convert(varchar(40
http://msdn.microsoft.com/