在数据库里插入数据注意点

[Boone301]

我玩了几天数据库，遇到了点问题，来和大家分享，希望大家少走弯路。

问题描述：

在往服务器上保存数据时，经常回保存当前时间，有时电脑的时间不准，会保存错误的数据。

解决方法：

插入服务器的时间，具体做发如下图：

QQ群：13267790

[ian_fung]

Wouldn't Format String is better, faster and neater for formating the date & time into string?

i.e. Example of using Format String 

 

[Boone301]

Yes, format is more clear:)

but need to add "\01date/time\01" before the string when insert into SQL as time.

Boone.

[ian_fung]

Hi Boone301 

That's for demo purpose...