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 expermenting with doing that it puts a 00:00 for the offset. Is there a way to do it and insert [...]

Answer Question   |  January 17, 2012  1:54 PM
DataType, DateTime

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

Answer Question   |  April 4, 2009  11:31 AM
DateTime

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) AS Waktu_Proses_Akhir, CONVERT(varchar, Waktu_Proses_Akhir - Waktu_Proses_Awal, 8) AS Waktu_Proses, Bulan, Tahun FROM dbo.Histori_Produksi This is [...]

Answer Question   |  March 5, 2009  8:25 PM
Data Types, DateTime, SQL Server, SQL Server DateTime, SQL Server errors

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 [...]

Answer Question   |  February 3, 2009  8:07 AM
C, Data Types, DateTime, SQL, VARCHAR, XML

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…

Answer Question   |  November 11, 2008  9:18 PM
DateTime, SQL Server stored procedures, Stored Procedures

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.

Answer Question   |  May 29, 2008  8:07 AM
DateTime, DBGrid, Delphi 5.0

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

Answer Question   |  May 28, 2008  9:49 AM
DateTime, Delphi 5.0

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 [...]

Answer Question   |  May 15, 2008  11:53 AM
DateTime, Microsoft Access

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

Answer Question   |  May 6, 2008  3:31 PM
DateTime, SQL Query Analyzer

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 conversion of a char data type to a datetime data type resulted [...]

Answer Question   |  April 25, 2008  3:34 PM
DateTime, SQL

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

Answer Question   |  April 1, 2008  6:38 AM
DateTime, Development, SQL