retrieving time

[Anon]

I am programming in ASP and trying to retrieve just the time from a table in sql database. The information is displayed, for example, 1/1/1900 3:19:07 PM. But I would like to just retrieving the time. Can someone please help. Thanks.

[brainiac]

This is, (if you haven't guessed), a PHP forum, but I guess you know how to retrieve the entire time/date from MySQL, when that has been retrieved, do a regexp that splits by the first space found, then show the latter part.

[brainiac]

in PHP I probably would have done something like this:
<?php
$timestamp = strtotime("1/1/1900 3:19:07 PM"); // convert string date to unix timestamp
$time = date("h:i:s A",$timestamp); // return only the hour,minutes, seconds in 12 hour format
echo $time;
?>

or if ASP are unable to work with unixtimes like this

<?php
$date = "1/1/1900 3:19:07 PM"; // putting the date into a variable
$time = stristr($date," "); // splitting at the first occurence of a space and returning the rest, including the whitespace where it splits.
$time = trim($time); // removing whitespaces at beginning and end.
echo $time; // echo $time.
?>

[Anon]

use vbscript

In asp first make date object

and then try datepart function

What database u are using ??
What value u have in your database filed from where u r retriving 1/1/1900 3:19:07 PM.

Well i don't know much about ASP But i'll try if u could explain ur problem more clearly..

Chanderjit