how to convert the time which is hh:mm:ss to mm:ss

156 100+

Hi every body to morning my cousine has show his application and also his live db in that to sav the length of all the voice files he has saved in time format ie he took the datatype of time now i want to generate a an excell sheet of that table but here i want the time to be like mm:ss but not hh:mm:ss examle

the length of song sweet dreams is 01:12:35 now i want this to be shown as
72:35 how is there any procedure to convert directly in mysql or should i have to use a frontend code if i have to use the frontend code i dont have any problem in bringing the values from db but how to covert is the problem some plz help me out

regards
seshu

Apr 1 '07 #1

Subscribe Post Reply

2045

je901

you can use Date.TimeOfDay.TotalMinutes for solve it.

example

Dim t As New Date(2007, 4, 1, 1, 12, 35)
MsgBox(Fix(t.TimeOfDay.TotalMinutes) & ":" & t.Second)

hope it helps.

Apr 1 '07 #2

Similar topics

convert duration in seconds to hh:mm:ss

by: hikums | last post by:

Does anyone have a function to convert duration in seconds to a format hh:mm:ss Thanks.

DB2 Database

Seconds as hh:mm:ss

by: Able | last post by:

Dear friends I need to format seconds as hh:mm:ss. I see a lot of coding transforming seconds to hh:mm:ss. Somebody know a short way? Regards...

Visual Basic .NET

Convert a double to a format of hh:mm:ss

by: Robert Brown | last post by:

Hi all. I have written a program that transfers data via FTP. I can calculate the rough amount of time left. I get a value such as 70.83 seconds...

Visual Basic .NET

Convert seconds to 00:00:00 (HH:MM:SS) format. Please help

by: Michael Barrido | last post by:

I have this for example: Dim iSeconds as int32 = 3600 '3600 seconds is one hour How do i convert it to "01:00:00" ? Please help. Thanks...

.NET Framework

why DateTime.ToString("hh:mm:ss") give 12:00:00 rather than 00:00:

by: Jason Chan | last post by:

DateTime mydate = new DateTime(2006,1,1,0,0,0); string testStr = mydate.ToString("hh:mm:ss"); //return 12:00:00 mydate = new...

ASP.NET

time conversions [hh:mm:ss.ms <-> sec(.ms)

by: kpp9c | last post by:

Hi, I was looking at python & datetime and hoping that it would already have a method/func to translate time formats. I need to translate...

Python

how to convert date time format as yyyyddmm hh:mm:ss in c#?

by: nirmalsingh | last post by:

i am getting date format in string as 30-11-2006 05:59:44 PM . i want to convert in the format of yyyy-mm-dd hh:mm:ss to sore it in mysql database....

.NET Framework

how to convert the time which is in hh:mm:ss to just mm:ss

by: seshu | last post by:

Hi every body to morning my cousine has show his application and also his live db in that to sav the length of all the voice files he has saved in...

MySQL Database

Convert HH:MM:SS into seconds

by: sudip77 | last post by:

Hi, I have an user input variable called @stop_time which takes input in the format of HH:MM:SS. I need to convert it into seconds only. How...

Microsoft SQL Server

How to Remove Duplicate Items from ComboBox in JavaFX?

by: tammygombez | last post by:

Hey fellow JavaFX developers, I'm currently working on a project that involves using a ComboBox in JavaFX, and I've run into a bit of an issue....

Java

Tips for Saving Money on Buying a Gaming Laptop

by: tammygombez | last post by:

Hey everyone! I've been researching gaming laptops lately, and I must say, they can get pretty expensive. However, I've come across some great...

Computer Hardware

Discuss your understanding of the Java platform.

by: better678 | last post by:

Question: Discuss your understanding of the Java platform. Is the statement "Java is interpreted" correct? Answer: Java is an object-oriented...

General

List of Topmost 8 Electronics Engineering Forum Websites

by: teenabhardwaj | last post by:

How would one discover a valid source for learning news, comfort, and help for engineering designs? Covering through piles of books takes a lot of...

General

How to minimize a tool bar that shows up when in reports

by: CD Tom | last post by:

This happens in runtime 2013 and 2016. When a report is run and then closed a toolbar shows up and the only way to get it to go away is to right...

General

https redirect with reverse proxy

by: jalbright99669 | last post by:

Am having a bit of a time with URL Rewrite. I need to incorporate http to https redirect with a reverse proxy. I have the URL Rewrite rules made...

IIS / Internet Information Server

Hyperconverged All-in-One Streaming Engine, ushering in new age for distributed database

by: antdb | last post by:

Ⅰ. Advantage of AntDB: hyper-convergence + streaming processing engine In the overall architecture, a new "hyper-convergence" concept was...

General

How to use http requests (Get function) to get variable value?

by: Matthew3360 | last post by:

Hi, I have a python app that i want to be able to get variables from a php page on my webserver. My python app is on my computer. How would I make it...

Python

HOW CAN I CREATE AN AI with an .executable file that would suck all files in the folder and on my computer

by: AndyPSV | last post by:

HOW CAN I CREATE AN AI with an .executable file that would suck all files in the folder and on my computerHOW CAN I CREATE AN AI with an .executable...

General