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

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,...

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

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

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.

Datetimepicker at runtime

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

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

datetime conversion

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

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

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