All Scripts backed by 10 years in business, free support, free updates and a 30 day money back guarantee.
Download Purchase Programming F.A.Q. Support Contact
Commercial Perl Scripts
All Form Pro Updated
Count It
Form Mailer + Attachments
Client File Manager
Da Godfaddah
Dropbox Updated
FAQ Builder
HT Manager Updated
RegisterHT
Mailing List Server
Page Updater - Text
Page Updater Pro Updated
PS Guestbook Updated
PS Lightning Search Updated
Quick File Mailer
Quick MySQL
Select-A-File
Upload Center
Free Perl Scripts
Access Log Viewer
All Form
Epoch Converter
Error Log Viewer
Invoice Center
PS Upload
Question Manager
Quick CHMOD
QuickHT
Site File Finder
Site File Lister
SSI Tag Maker
Perl Modules
Monger Calendar
Monger File
Monger Mail
Monger Persist
JavaScript Generators
PopUp Windows
Meta Gen
RGB / Hex Converter
Page Colors
Sudoku
Tutorials and FAQs
Cookies
Using CuteFTP
Using WS_FTP
Installing Scripts
Debugging
Utilities
env_vars.pl
backup.pl
restore.pl
check_email.pl
date.pl
dayname.pl
fileage.pl
format_length.pl
format_url.pl
getfile.pl
parse.pl
redirect_html.pl
Free Services
Epoch Converter
TLD Registries
RGB/Hex FInder
Colour Checker
ASCII Codes
Policies
Terms and Conditions
Privacy Policy
Refund Policy
Site Map

Form Processor with no SPAM from robots.

Anti-spam, anti-robot, anti-flame, Guestbook for your website.

Manage Remote websites from your website. Allow clients to update sections of their own web pages.

Secure file manager with upload progress meter. A printer's best friend. Find out more.

Epoch Convertor Users Guide

Click here to download your own copy. Requires Mysql.pm on a Unix Server
Click here to test the script
  1. Requirements
  2. Configuration
  3. Installation
  4. Converting dates and timestamps


Requirements

Epoch Converter requires the Mysql.pm Perl Module installed on a Unix or Linux server. And of course Perl.

To Top

Configuration

Add your database connection details at the top of the epoch_converter.cgi script :

$DBHOST = "localhost";
$DBNAME = "databasename";
$DBUSER = "username";
$DBPASS = "password";

You can connect to any existing mysql database you like. The script does not store any data anywhere. it just needs to connect to mysql and send a query to it. Mysql will then process the query and return it's results.

You'll also find an offset variable. This needs to be set so that the returned time stamps and unix dates are returned as G.M.T. If your server is located in a time zone of GMT +1, you need to set the offset variable to 3600 seconds, which is 1 hour. If your server is located in a time zone of GMT -2, you need to set the offset variable to -7200 seconds, which is negative 2 hours. Once installed, you can then test your setting by entering "1" in the "Seconds to Epoch" field and the script should return January 1st, 1970 12:00:01 AM

To Top

Installation

Refer to our Script Installation FAQ if you run in to any problems. Here are the basic steps.

1) Upload epoch_converter.cgi in ASCII mode to your cgi-bin and CHMOD it to 755
2) Upload epoch_converter.html anywhere you like, but make sure the two forms in it point to the location of the epoch_converter.cgi script you uploaded
3) Load epoch_converter.html in a browser and test it.

To Top

Converting dates and timestamps

Simply enter a unix time stamp or select a date from the fields provided and press the relevant Submit button. Easy, fast, efficient and extremely accurate. That's what MySQL is.

To Top

  ©2009 All rights reserved, PerlServices.net. Website hosting by LinuxHostingPlans.com