1
  • Converting date time in C#

    hi all, I have a column called WBsstartdate (storing dates), that has been created as a Varchar data type. If I run a convert on the table, my date comes out in the right format. (Eg: 2006-04-03 00:00:00). This is fine. However when I run this date as an sql query in a programme in C#, and save to...

    Zubairm765 pointsBadges:
  • How to change datetime values in SQL Server?

    I want to present a datetime value without hours, minutes or seconds in SQL Server 2008? Would this code work?Statement @SomeDate datetime = '2013-09-18 16:30:22' select trunc_date(@SomeDate) ----------------------- 2013-09-18 00:00:00.000

    ITKE828,900 pointsBadges:
  • DateTime to DateTimeOffset

    Hi, we currently have a table with over a billion rows recorded with a datatype of datatime that spans across 6 years. We would like to change the datatype to date time offset but after experimenting with doing that it puts a 00:00 for the offset. Is there a way to do it and insert the correct...

    Bru5 pointsBadges:
  • Date formats in SQL Server Stored Procedures

    This one will be easy, I'm sure. I'm a novice at Stored Procedures, and I'm wondering what function I can use to display a smalldatetime field (currently displaying as Dec 19, 2008 12:00AM) as a short date (12/19/2008)? I am on SQL Server.

    Wandasoozq5 pointsBadges:
  • DBGrid in Delphi

    Can anyone tell me how to embed a datetimepicker and checkbox in DBGrid in Delphi at runtime.Please provide me pointers asap.

    Rajalakshmi08240 pointsBadges:
  • How do I find Datetime of ESX server in C#?

    How does one find ‘datetime’ of an ESX server in C#? When a VM reboots it normally gets the time of the BIOS time. It is that time that I want to display I as a ‘datetime’ object. Where are things going wrong in this code I am trying to use to make this happen? private DateTime...

    ITKE828,900 pointsBadges:
  • Convert string to Datetime in SQL Server 2008

    In SQL Server 2008, I have a string column in my table that displays data like this: "CXL P/D 08/15/13" Now, I'm trying to convert it to datetime but I can't understand how to extract only the date and change the data type. Could someone help me find the right statement?

    ITKE828,900 pointsBadges:
  • Return a tuple of datetime objects in Python

    I want to write a function that returns a tuple of (start,end) where start is the Monday at 00:00:00:000000 and end is Sunday at 23:59:59:999999. start and end are datetime objects. No other information is given about day, month or year. i tried this functiondef week_start_end(date):start=...

    michaels325 pointsBadges:
  • Does SQL Server 2008 lack “datetime”?

    Does SQL Server 2008 allow for the datatype “datetime”? I’ve primarily worked on SQL Server 2005. I found out about the gap when I built an entity framework model while using a 2008 database. When I tried to update the entity on a 2005 database I got the following error: The version of SQL...

    ITKE828,900 pointsBadges:
  • Date/time Calculation

    I want to calculate the Date/time in hours when the document is in status of "Work in Progress" by using starttime and endtime

    Chowdary165 pointsBadges:
  • Finding the average of a data type on a SQL Server

    I am trying to figure how to find the average of the data type datetime on my SQL Server. This is my code: SELECT CONVERT(varchar, Tanggal_Produksi, 3) AS Tanggal_Produksi, Target, Actual, Balance, CONVERT(varchar, Waktu_Proses_Awal, 8) AS Waktu_Proses_Awal, CONVERT(varchar, Waktu_Proses_Akhir, 8)...

    SQL Server Ask the Experts2,585 pointsBadges:
  • Datetimepicker at runtime

    Can anyone tell me how to embed the datetime picker at run time id delphi

    Rajalakshmi08240 pointsBadges:
  • Convert time as text to datetime

    I've got a stupid table that I have to work with (and no, I can't change it) that stores times of certain events as text (example: '10:25 pm' or '3:02 am'). This table has an actual date to work with, which is essentially just the date with no time component. Know what I'm going to ask yet? You...

    VentureFree45 pointsBadges:
  • datetime conversion

    SQL Analyzer has issues w/below relative to the datetime conversion- - what is the problem? convert(varchar(10),ft.postdate,101) 'PostDate',

    Mictip5 pointsBadges:
  • SQL Error: Conversion of char data type to a datetime data type resulted in an out of range datetime value

    A reader wrote in with this question, but it's not one that our AS/400 experts could answer. So any Microsoft SQL experts out there, please chime in: I am an SQL novice.......I am getting the following error message: [Microsoft][ODBC SQL Server Driver][SQLServer] The...

    Leah Rosin600 pointsBadges:
  • DATETIME calculation

    Hi there, this is probably very simple but i just can't get it working. I want to subtract one month from a variable month. So if the datetime variable is equal to 10 Feb 2008 the result should be 10 Jan 2008. Please help. Thanks

    Barend IT15 pointsBadges:
1

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following