SQL Timestamp

Comments

• pavsta Beginner Link Clerk

  January 2005

  I can help you here, basically if i remember rightly you need to convert the timestamp data, first fetch the info from the database, ill call the field with the timestamp 'time' and the variable that fetch's it ill call $grab, now this is the code you need:
  
  $date = date("d/m/Y G:i:s","$grab[time]");
  
  and so when the $date variable is called it will display something like: 20/1/2005 23:54:05
  
  - Hoped this helped.
• Python Forum Leader The Royal RAM

  January 2005

  ahh rite i see... so you actually define th order in which it is all outputted. Ok thanks

  The Royal Ram
• pavsta Beginner Link Clerk

  January 2005

  yep, thats the best thing!
• Arestia Member NAT Warrior

  January 2005

  i use this to format timestamps, timestamp(14) that is
  

  <?php
  function format_timestamp($timestamp)
  {
  	$year = substr($timestamp, 0, 4);
  	$month = substr($timestamp, 4, 2);
  	$day = substr($timestamp, 6, 2);
  	$hour = substr($timestamp, 8, 2);
  	$minute = substr($timestamp, 10, 2);
  	$second = substr($timestamp, 12, 2);
  	if($hour >= 12)
  	{
  		if($hour > 12)
  		{ $hour = $hour - 12; }
  		$ampm = "PM";
  	}
  	else
  	{
  		$hour = $hour - 0;
  		$ampm = "AM";
  	}
  	$formatted = $year.".".$month.".".$day." - ".$hour.":".$minute." ".$ampm;
  	return $formatted;
  }
  ?>
  

  
  then you can call it using
  

  format_timestamp($myrow[yourtimestamp])
  

  
  and this the style it displays "2005.01.25 - 9:05 PM".
  
  you can format the $formated variable to your liking.
  
  -Dan

  Arestia Design Studios / Synapse Corporate Solutions
  Daniel L. Rust - Lead Architect
  Seattle, WA
• Python Forum Leader The Royal RAM

  January 2005

  well thats a lot more code but yeah that seems fairly good

  The Royal Ram