| View previous topic :: View next topic |
| Author |
Message |
dbdesigns
Joined: 22 Jun 2002
Posts: 18
Location: Mumbai, India
|
 Posted: Tue Jun 25, 2002 7:26 am Post subject: Setting Correct Time Zone |
 |
|
I had to post this again, sorry! But no 1 solved my problem. Alrite here it goes:
dbdesigns: (My Question)
want to set my time to to GMT + 5.5 but it saves as GMT + 6, how do I make it +5.5
michealv: (Suggestion)
Check the Time Difference field in Options. That's where you can correct timezone offset.
For example, if your server is on GMT +6 and you are on GMT +5.5, put -0.5 as the Time Difference.
dbdesigns: (Yet my problem)
Yes, I have aleady checked that. If I enter it as -0.5, it get converted to a round figure it 0 or -1 but it doesn't remain -0.5. What can I do now ? I have even tried to change it by making changes in sql server but yet it doesn't work. Plz help! |
|
| Back to top |
|
 |
.Chris
Joined: 30 Apr 2002
Posts: 186
Location: Hawaii
|
| Posted: Tue Jun 25, 2002 11:13 pm Post subject: |
|
|
Maybe I'm dumb, but I've never heard of a "half" hour timezone.
Last edited by .Chris on Thu Nov 07, 2002 7:56 pm; edited 1 time in total |
|
| Back to top |
|
|
Nodecam
Joined: 05 Apr 2002
Posts: 66
Location: Saskatoon, Saskatchewan, Canada
|
| Posted: Wed Jun 26, 2002 3:37 pm Post subject: |
|
|
Everyone in Canada has - stuff on CBC (The public funded TV network) is always on at 7:00 - 7:30 in Newfoundland (For example)
I don't know of others, but obviously they exist  |
|
| Back to top |
|
|
michel v
Site Admin
Joined: 25 Jan 2002
Posts: 799
Location: Corsica
|
| Posted: Wed Jun 26, 2002 8:20 pm Post subject: |
|
|
OK, I see the problem is with how the b2settings table is set up. time_difference is a column of type INT, where it should be FLOAT.
It will be fixed in future releases.
Here's a temporary fix that yu can apply: | Code: | <?php
# correct time_difference bug
include("./b2config.php");
include("$b2inc/b2functions.php");
dbconnect();
$sql = "ALTER TABLE $tablesettings CHANGE time_difference time_difference FLOAT(4) DEFAULT '0' NOT NULL";
$result = mysql_query($sql) or die("<p>There's a problem.</p><p>Here's the SQL query:<br />$sql</p><p>MySQL said:<br />".mysql_error());
echo "You fixed the timezone problem. You can safely delete this file now.";
?> |
Save that as timezonefix.php (or whatever name you fancy), upload it in your b2 directory, and load it in your browser.
It will fix the time_difference column, allowing you to use -0.5 |
|
| Back to top |
|
|
kaiden
Joined: 20 Mar 2002
Posts: 43
|
| Posted: Wed Jun 26, 2002 11:42 pm Post subject: |
|
|
| very clever Michael, I will have to remember this. |
|
| Back to top |
|
|
cLin
Joined: 01 Jul 2002
Posts: 13
|
| Posted: Mon Jul 01, 2002 5:06 am Post subject: |
|
|
| when you say server timezone, are you referring to the server of where yourfiles are hosted? because right now i posted at 6 PM and it shows at 9 PM and i want to make it so it shows the timeon my computer, the clock that is |
|
| Back to top |
|
|
mysteryman
Joined: 15 May 2002
Posts: 54
Location: Texas
|
| Posted: Mon Jul 01, 2002 6:02 am Post subject: |
|
|
| cLin wrote: |
when you say server timezone, are you referring to the server of where yourfiles are hosted? because right now i posted at 6 PM and it shows at 9 PM and i want to make it so it shows the timeon my computer, the clock that is
|
Yes, and what you want and need to do is under options at the top of b2edit.php, between Team and Categories.
This is what it looks like:
Your time difference would be -3 where mine is -7. |
|
| Back to top |
|
|
cLin
Joined: 01 Jul 2002
Posts: 13
|
| Posted: Mon Jul 01, 2002 6:10 am Post subject: |
|
|
| i did that, now i dont even see the entries... |
|
| Back to top |
|
|
mysteryman
Joined: 15 May 2002
Posts: 54
Location: Texas
|
| Posted: Tue Jul 02, 2002 1:37 am Post subject: |
|
|
| I don't know what would cause that, but you might be able to logout and close your browser, then open it again and log back in. I know sometimes when I post on forums the pos I am working on will dissappear when I add different elements and hit enter. Usuallly a refresh will bring it back though. |
|
| Back to top |
|
|
Nimil
Joined: 19 Mar 2003
Posts: 1
|
| Posted: Wed Mar 19, 2003 4:14 pm Post subject: |
|
|
| i know this is an old post, but i'm having the same trouble and i can't seem to get my time to be accurate... |
|
| Back to top |
|
|
beachgerl
Joined: 14 Apr 2003
Posts: 37
Location: San Diego
|
| Posted: Mon Apr 14, 2003 3:08 am Post subject: |
|
|
I noticed the time is all wrong on weblog itself while I correctly set up time difference and timezone in Options page of b2 admin panel. Why isn't the weblog itself displaying the correct time? For example, when it's actually 7 pm but my weblog shows 4 pm instead. Is this a bug and how do I remedy this?
Thanks. |
|
| Back to top |
|
|
beachgerl
Joined: 14 Apr 2003
Posts: 37
Location: San Diego
|
| Posted: Wed Apr 16, 2003 12:49 am Post subject: |
|
|
| beachgerl wrote: | I noticed the time is all wrong on weblog itself while I correctly set up time difference and timezone in Options page of b2 admin panel. Why isn't the weblog itself displaying the correct time? For example, when it's actually 7 pm but my weblog shows 4 pm instead. Is this a bug and how do I remedy this?
|
I overlooked this part in ReadMe.html. I have this finally resolved. I shouldn't have skipped last part of Read Me file.
| Quote: | Template tags are these:
<?php the_time() ?>
the time of the post. example: 18:37:00 (default is hh:mm:ss)
Parameters:
* format string (default: "H:i:s")
eg: Make the change to <?php the_time("H:i:s A") (or whatever format you prefer) from <?php the_time() in your template if you're using one.
Note: you can change the way the date & time are displayed in the Options page.
once you understand the format strings for the date & time (explained in the Options page), you can change the display right on the template: for example, the_date("d.m.Y") to have dates like 25.12.2001, the_time("B") to have Swatch Internet Time.
If you change the display of the date on the template, changing it from the options page won't have any effect.
Note about the_date(): if you want all your posts to bear the date, you'll have to use the_time() instead, with a date format string. for example, to have all your posts show like "25.12.2001 @ 8:04:50 AM" you'll have the_time("d.m.Y @ g:i:s A"). You can also repeat this template tag 2 times with 2 different formats: the_time("d.m.Y") for the date, and then later the_time("g:i:s A") for the time of the day. |
|
|
| Back to top |
|
|
Sushubh
Joined: 30 Jun 2003
Posts: 44
Location: India
|
| Posted: Wed Jul 09, 2003 3:15 pm Post subject: |
|
|
| .Chris wrote: | | Maybe I'm dumb, but I've never heard of a "half" hour timezone. |
Well, India's timezone is +5.5 that means 1 Billion people in this world live in this time zone.
And the php file solves the problem.
_________________
My Blog | Why Opera? 1 2 | No to Internet Explorer? |
|
| Back to top |
|
|
Sigg3
Joined: 03 Jul 2003
Posts: 632
Location: Oslo, Norway
|
| Posted: Sat Jul 12, 2003 5:20 pm Post subject: |
|
|
I just checked my showtime feature now, because I've noticed it has been wrong a long time;
When I post @ 18:12 or 6:12 pm, the time says 6:50, hence adding 38 minutes (which is too much for me to consider it 'ok').
Now, in b2options.php the time difference is set to 1. 1 is 1 hour, right?That should mean I should really put it to something like +20 minutes, but as I've figured the b2options.php won't have minutes, so what do I do? |
|
| Back to top |
|
|
scarbittenross
Joined: 17 Nov 2002
Posts: 22
Location: Ayr, Scotland
|
| Posted: Sat Jul 26, 2003 11:42 pm Post subject: |
|
|
I am in GMT.. I've added +6 into the time zone different, but i'm still on New York Time??
Argh.
_________________
[w] http://www.scarbitten.co.uk
[quote] " Remember, today is the tomorrow you worried about yesterday." |
|
| Back to top |
|
|
|
FAQ
Search
Memberlist
Usergroups
Register
Profile
Log in to check your private messages
Log in
