How to get Time with Am and PM in sql and vb.net ?

Question

0.00/5 (No votes)

See more:

Hai
How to get current Time with Am and Pm in vb.net and sql ?
like 11:00 Am or 02:20 Pm (or 2:20 Pm).No need secs,ms and so... and what datatype need to give sql server column for capture in the table ? navarchar() or varchar() smalldatetime or Date or Time.

note: i need to save time with Am and Pm (11:00 Am )in sql server.

Regards
ARavindb

Posted 10-Dec-13 21:39pm

Aravindba

Updated 10-Dec-13 21:44pm

v2

Add a Solution

3 solutions

Solution 1

Use datatype as

DateTime

And to get datetime in specified format use

CONVERT(VARCHAR,GETDATE(),119)

function. And for more details please refere -> http://www.w3schools.com/sql/func_convert.asp[^]

Posted 10-Dec-13 21:47pm

LaxmikantYadav

Updated 10-Dec-13 21:52pm

v2

Solution 3

Aravindba wrote:

note: i need to save time with Am and Pm (11:00 Am )in sql server.

Bad design!
You should store date as date data type not as varchar for set of resons:

query performance

database performance

easiest way to operate on data

etc.

Posted 11-Dec-13 11:19am

Maciej Los

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Aravindba · Accepted Answer · 2013-12-10T21:49:00

Solution 2

Dim a As String = DateTime.Now().ToString("hh:mm tt")
i will get what i except like 02:20 Pm

Posted 10-Dec-13 21:49pm

Aravindba

Updated 10-Dec-13 21:50pm

v2

Comments

Goenitz 17-Dec-13 21:45pm

What if i have a user input time? for example the user input is 08:00 AM(STRING) how can i convert it to time?

Aravindba 18-Dec-13 0:00am

user manually enter time ? but in my above answer is get current system time and convert as string

Goenitz 18-Dec-13 0:12am

I said "what if" :), if its the case how can i convert it to time?

Aravindba 18-Dec-13 0:19am

Dim a As DateTime = DateTime.Now().ToString("hh:mm tt") try like this,it will get time as datetime,if u declare variable as DateTime then it is time not string

Goenitz 18-Dec-13 2:04am

Lets make this clear, I have a string variable = 08:00 AM , now how can i convert this to time data type so that my database will accept it?

Aravindba 18-Dec-13 2:27am

how u declare variable ? can u type here , dim aaa as datetime or dim aaa as string ? or chnage datatype in sql server as nvarchar(50),then it accept all,like number,string anything,no need to convert.

Goenitz 18-Dec-13 2:38am

Dim time as String = 08:00 AM, then my fieldname in database is (Time ,time(7))

Aravindba 18-Dec-13 2:50am

i am also face this same problem,if u remove AM,then it insert into sql if datatype (Time ,time(7)),so u change (Time ,nvarchar(50)) and in insert query u use Dim time as String = 08:00 AM

Goenitz 18-Dec-13 2:58am

I got it :), change the datatype of the string to time in your query before inserting into database, hope this helps you also
Happy Coding