|
|
Browse by Tags
- 2000
- 2005
- 22008
- 8115
- access
- activex
- alter
- assigning
- automatically
- axscriptxform
- between
- bulk
- business intelligence studio
- cast
- caused
- cf_sql_timestamp
- char
- character
- column
- columns
- compare
- comparison
- conversion
- convert
- Convert a String To DateTime Format
- converting
- create
- createdatetime
- crystal
- current
- data
- date
- Date Comparison to SQL Datetime
- datediff
- datepart
- day funtion
- days
- db2
- declaring
- default
- Default time & date for mySql datetime field
- dimension
- double
- dts
- duplicate
- during
- error
- excel
- extract
- extracting
- failed
- field
- firebird
- format
- formatprovider
- formatting
- fraction
- from
- get
- getdate
- getfieldvalue
- incompatible
- informix
- insert
- inserting
- int
- interbase
- invalid
- java
- mssql
- mysql
- only
- oracle
- overflow
- query
- reporting
- serial
- server2008
- services
- show
- sql
- SQL2005
- sqlite
- SSAS
- SSRS
- stored
- string
- strip
- subtract
- sybase
- syntax
- syntaxe
- sysjobhistory
- table
- time
- trigger
- type
- update
- value
- varchar
-
Default time & date for mySql datetime field
In MS Access, you can put "Now()" in a date field and it will automatically insert the date and time when you add a record to the db. Is there something similar for MySql? I have a datetime field which I want to insert the date & time automatically cuz I'm too lazy to stick in one more... -
Date Comparison to SQL Datetime
How to you do a date comparison to a datetime. ie: Have a datetime in a database and want to get all records for a single date. -
Convert a String To DateTime Format
Hi experts, I have a problem with datetime format in PHP Example : I have a string : "2007-10-06 20:45:00" (a datetime string) , and How to that string convert to "20:45 06-10" ? Thanks & Regards TrungGN -
Microsoft Access Format datetime from dd/mm/yyyy hh:mm:ss to mm/dd/yyyy hh:mm:ss
I am currently retrieving the date time in one of the text box in a form Dim checkDate As Date checkDate = Me.DTTXT the checkdate is in dd/mm/yyyy hh:mm:ss format. I want to convert it to mm/dd/yyyy hh:mm:ss How can I do it? whats the syntax? -
sqlite database - timestamp, date, time
hello all - i'm using the ADO.NET Data Provider for SQLite to insert some date / time records. the data is inserting fine, but once it's in my sqlite db, it's not behaving correctly when i attempt to do an ORDER BY, or if i attempt to return a range of fields (Stamp > 8/14/2006 03:45:00... -
MySql DateTime with C#
here is my INSERT Statement: ("INSERT INTO STUDENT (FNAME,LNAME,EMAILADDRESS,DATE) VALUES ('LName','FName','email@server.com','{0}')",DateTime.Now.ToShortDateString()); using ODBC, this operation add a new record but the DateTime field is NULL... any ideas why... -
DateTime question in C#
I am writing this piece of code in a C# application in MS Visual studio. I want to use GMT (or UTC) time throught in the application. I do not want to use the local time to show up anywhere in the application page. Here are my code -- it does not compile: DateTime date1 = Convert.ToDateTime(runDate);... -
How to find out day of week in SQL
Hi everyone, So I need to find out if a date entered is a Sunday. If it is, I gotta do something special with this data. I'm not sure if Datepart will help or how to use it effectively to extract if it's a Sunday or if it's 1st day of the week (well if the week starts at Sunday). Any help... -
monthly report, MySQL - DateTime
Hi, I have my_date field in my table that contains DATETIME format (2004-03-01 17:34:57) for every uploaded document. Now, every month I want to retrieve documents in the range of 2004-currentMonth-01 through 2004-currentMonth-30. So, basicly it's kind of monthly report for current month only beginning... -
Problem with MAX on datetime column in Mysql.
Hello all, Using Mysql, and having a problem with the MAX function on a datetime column. Table accounts has information about some accounts, with many columns. Three of the columns are: account_id, type=integer, contact_id, type = integer, and last_update, of type datetime. Every time any account's...