How to get the Time value from datetime picker

Posted by Ranjana on Stack Overflow See other posts from Stack Overflow or by Ranjana
Published on 2010-04-03T06:24:53Z Indexed on 2010/04/03 6:33 UTC
Read the original article Hit count: 355

Filed under:

datetimepicker

|

datetime

|

c#

|

stored-procedures

how to get the time value in a stored procedure form datepicker value

i.e i have a datetime picker value stored into my table as '2010-04-06 09:00:00.000' '2010-04-07 14:30:00.000'

i have got the date sepeartely using convert(varchar,Date,3) as Date.. i have got the time seperately using convert(time,Time)

but it show the values as 9:00 , 14:30

i need it to show as 9.00 am and 2.30pm instead of 14.30.

How to achieve this????????? and help??????

© Stack Overflow or respective owner

Related posts about datetimepicker

DateTimePicker automatically move to next datepart

as seen on Stack Overflow - Search for 'Stack Overflow'
Currently, when using the datetimepicker, after you enter the month you have to either hit the right arrow or the "/" for it to move to the day. Is there a property that I can set or a way to know that the month is done and move to the day and move to the year after the user is done with the day?… >>> More
Data type mismatch when retrieving records from an access database using a DateTimePicker

as seen on Stack Overflow - Search for 'Stack Overflow'
I get a Data type mismatch criteria expression error when i try to retrieve records from an access database between two dates using a DateTimePicker in C#. This is the Select statement else if (dtpDOBFrom.Value < dtpDOBTo.Value) { cmdSearch.CommandText = "SELECT [First Name], [Surname], [Contact… >>> More
C# how to display datetimepicker control for all rows of gridview

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi, In my application I am creating rows and columns dynamically. I created a column of type System.DateTime. After this i want to display datetimepicker control for all rows in that column. I created a column using dataTable.Columns.Add("CreatedOn", Type.GetType("System.DateTime")); and i am… >>> More
DateTimePicker Dialog in C#

as seen on Stack Overflow - Search for 'Stack Overflow'
I need to have a pop-up dialog like the Color Dialog or Save Dialog but for choosing a date from a calendar. The DateTimePicker is what I need, but I don't know how to launch this like a pop-up dialog in C#. >>> More
DateTimePicker replacement that "respects" e.g. the CurrentUICulture

as seen on Stack Overflow - Search for 'Stack Overflow'
Apparently the DateTimePicker does not "respect" or adhere to the CurrentUICulture of a .NET application, because DateTimePicker is a "Native" Common-control with a .NET wrapper (I think). I have a requirement to display "AM/PM" regardless of the regional settings of the PC running my .NET Winforms… >>> More

Related posts about datetime

Finding begin and end of year/month/day/hour

as seen on Stack Overflow - Search for 'Stack Overflow'
I'm using the following snipped to find the begin and end of several time periods in Joda. The little devil on my left shoulder says thats the way to go... but I dont believe him. Could anybody with some joda experience take a brief look and tell me that the little guy is right? (It will be only… >>> More
Get non-overlapping dates ranges for prices history data

as seen on Stack Overflow - Search for 'Stack Overflow'
Hello, Let's assume that I have the following table: CREATE TABLE [dbo].[PricesHist]( [Product] varchar NOT NULL, [Price] [float] NOT NULL, [StartDate] [datetime] NOT NULL, [EndDate] [datetime] NOT NULL ) INSERT [dbo].[PricesHist] ([Product], [Price], [StartDate], [EndDate]) VALUES (N'Apples'… >>> More
DateTime.MinValue vs new DateTime() in C#

as seen on Stack Overflow - Search for 'Stack Overflow'
When getting SQL DateTime Resharper suggests to use new DateTime() when value is DBNull.Value. I've always used DateTime.MinValue. Which is the proper way? DateTime varData = sqlQueryResult["Data"] is DateTime ? (DateTime) sqlQueryResult["Data"] : new DateTime(); >>> More
SOLVED: Error 1 Ticks must be between DateTime.MinValue.Ticks and DateTime.MaxValue.Ticks

as seen on Dot net Slackers - Search for 'Dot net Slackers'
This is a simple looking error message that is deceptively hard to track down. Thankfully if you're having this problem then this article should get you back on track without spending hours scratching your head. Scenario It was time to update an existing website so after synchronising my copy of… >>> More
Converting Openfire IM datetime values in SQL Server to / from VARCHAR(15) and DATETIME data types

as seen on Geeks with Blogs - Search for 'Geeks with Blogs'
A client is using Openfire IM for their users, and would like some custom queries to audit user conversations (which are stored by Openfire in tables in the SQL Server database). Because Openfire supports multiple database servers and multiple platforms, the designers chose to store all date/time… >>> More