hi i am doing a attendance sheet appln...
i want to know how to get the current indian time,date,month and year.....
and i want to store that in mysql database
lydia
lydia21
9
Junior Poster
Recommended Answers
Jump to PostIf you want current date and time to insert to a table, you can use now() function of mysql.
http://dev.mysql.com/doc/refman/5.1/en/date-and-time-functions.html#function_now
Jump to Post<?php $time_now=mktime(date('h')+5,date('i')+30,date('s')); print "<br>".date('h:i:s A',$time_now); ?>Thats for php.
Cheers,
Naveen
Jump to PostI am getting the right output. i am getting 03:14:16 PM which is the right time.
$time_now=mktime(date('h')+5,date('i')+30,date('s'));
date('h')+5 will add 5 hrs to UTC time.
date('i')+30 will add 30 mins to UTC time.Since we are 5-30 hrs ahead of UTC time, i am sure this will …
All 12 Replies
nav33n
472
Purple hazed!
Team Colleague
Featured Poster
If you want current date and time to insert to a table, you can use now() function of mysql.
http://dev.mysql.com/doc/refman/5.1/en/date-and-time-functions.html#function_now
lydia21
9
Junior Poster
thanks for the reply..but use tat in php....
nav33n
472
Purple hazed!
Team Colleague
Featured Poster
<?php
$time_now=mktime(date('h')+5,date('i')+30,date('s'));
print "<br>".date('h:i:s A',$time_now);
?>Thats for php.
Cheers,
Naveen
lydia21
9
Junior Poster
09:42:53 AM...output
but my system timing is 3.00pm
nav33n
472
Purple hazed!
Team Colleague
Featured Poster
I am getting the right output. i am getting 03:14:16 PM which is the right time.
$time_now=mktime(date('h')+5,date('i')+30,date('s'));
date('h')+5 will add 5 hrs to UTC time.
date('i')+30 will add 30 mins to UTC time.
Since we are 5-30 hrs ahead of UTC time, i am sure this will work. It probably wont work if you have set some other timezone. :)
lydia21
9
Junior Poster
can i know why u have given "<br>"...
Time<input type="text" name="dat1" value=<?php
$time_now=mktime(date('h')+5,date('i')+30,date('s'));
print .date('h:i:s A',$time_now);
?>>
because the about statement is not working
nav33n
472
Purple hazed!
Team Colleague
Featured Poster
<br> is to give a line break. That doesnt make any difference. Do you want indian time to be put in a text box ? Try this.
<html>
<body>
<?php
$time_now=mktime(date('h')+5,date('i')+30,date('s'));
$time_now=date('h:i:s A',$time_now);
?>
Time: <input type="text" name="dat1" value="<?php echo $time_now; ?>">
</body>
</html>
sunilcsit
0
Newbie Poster
Hi this is sunil,
pls see this code,
$time_now=gmmktime(date('h')+5,date('i')+30,date('s'));
print "<br>".date('h:i:s A',$time_now);
tyson567
1
Newbie Poster
just use two line of codes...
$date = date_default_timezone_set('Asia/Kolkata');
$today = date("F j, Y, g:i a T");in the php code and use $date where you want your values to reflect...That's it.
newbie1234
commented:
correct
+1
codepagla
0
Newbie Poster
This code will benefit many people
azharkhan077
0
Newbie Poster
Thnks @nav33n.
Its Help me a lot.
kharthikeyan
0
Newbie Poster
Use Time Zone
<?php
$date = date_default_timezone_set('Asia/Kolkata');
echo date("d/m/Y h:i:s a", time());
?>
Or Use Time Diferrence from GMT
<?php
$time_now=mktime(date('h')+5,date('i')+30,date('s'));
echo date("d/m/Y h:i:s a", time());
?>
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.