|
|
Please consider registering: registration is fast, easy and free! Benefits of registration:
- Free advertising for your website: Every post in our forums goes towards a "credit" of ads, which are displayed on most pages of our forums. Each post gives you 400 ad impressions. To submit your ad, edit your profile.
- Discount at TemplateMonster: All our members enjoy a 20% discount at TemplateMonster.com!
|
- Private Messages: Exchange private messages with other members of the forums.
- Message Tracking/Subscription: phpBB enables you to subscribe to threads which interest you, and will then email you when a reply is posted. phpBB also remembers which posts registered users have read during a session, which means you can keep track of which posts you have already looked at.
|
|
| Author |
Message |
nareshphp
Junior WebHelper
Joined: 19 Jul 2007
Posts: 1
|
 Posted:
Thu Jul 19, 2007 11:16 am (3 years, 1 month ago) |
  |
I've inserted a record into mysql db using now() function value.
just like...
insert into TABLE_NAME(date,name,age)values(now(),'Naresh','24')
when tried to echo the date filed value on the local system,it gives me 2007-06-06 13:14:16.
But on the live system it gives me as 20070606131416.
It's weird and i can't understand what the problem.
And need to get the same format exactly as on the local system.
I need that format for my database queries.
can any one help me out here?
Thanks in advance. |
|
|
    |
|
ddemetrius456
Junior WebHelper
Joined: 22 Oct 2009
Posts: 6
|
| Posted:
Wed Oct 28, 2009 3:31 am (10 months, 2 weeks ago) |
|
TABLE_NAME(date,name,age)values(date(),'Naresh','24').
This will solve your problem. |
|
|
|
|
|
|
|
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot edit your posts in this forum.
You cannot delete your posts in this forum.
You cannot vote in polls in this forum.
|
Page generation time: 0.037036 seconds :: 15 queries executed :: All Times are GMT
Powered by phpBB 2.0
© 2001, 2002 phpBB Group :: Based on an FI Theme
| |
