Home > database >  Just the 1900-1-1 why when you pick up the SQL server time!!
Just the 1900-1-1 why when you pick up the SQL server time!!

Time:10-04

Server time is very normal!!!!
The date ldt_temp
The select getdate () into: ldt_temp from pbcatcol;

Messagebox (" ", string (ldt_temp))

After the operation showed that
The 1900-1-1

CodePudding user response:

Datetime ldt_temp
The select getdate () into: ldt_temp from pbcatcol;

Messagebox (" ", string (ldt_temp))

CodePudding user response:

Datetime ldt_temp
Select the top 1 getdate () into: ldt_temp from pbcatcol;

Messagebox (" ", string (ldt_temp))

CodePudding user response:

Select the top 1 getdate () into: ldt_temp from pbcatcol;
good

CodePudding user response:

Problem solving and list data!!!!!! Dizzy...

CodePudding user response:

Jie tie gei fen.

CodePudding user response:

Late again
The original poster also give points ah ~!

CodePudding user response:

I am a novice, can you tell me how to give hair!!! I'm sorry I don't do it!!!!!!

CodePudding user response:

Click the top management, and then, the input password, can spread,

CodePudding user response:

I'm sorry I don't do it!!!!!!

Don't make software do?? That not only into?

CodePudding user response:

This post is not knot.

CodePudding user response:

Ha ha to really, give me LZ also scatter

CodePudding user response:

I changed a 0, can't buy!!!!!!

CodePudding user response:

In the oracle database,
The select sysdate
Into: ss
The from sys. Dual
In the other database, such as the sqlserve, sybase, asa database
Declare getdate dynamic procedure for sqlsa;
Prepare sqlsa from "select getdate ()"
The execute dynamic getdate;
The fetch getdate into: ldt_serverTime
The close getdate

CodePudding user response:

Query the value does not exist, the database will return 1, so according to this
  • Related