How to Declare DateTime

Dev Shed Forums Sponsor:

August 2nd, 2012, 12:36 PM

Registered User

Join Date: Aug 2012

Posts: 2

Time spent in forums: 18 m 20 sec
Reputation Power: 0

How to Declare DateTime

how can i can change this sql code into postgres code:
DECLARE @startDate datetime
SET @startDate = '20090601'
thanks

August 2nd, 2012, 12:45 PM

pollyanna

Join Date: Jul 2012

Location: Germany

Posts: 1,879

Time spent in forums: 1 Month 2 Weeks 2 Days 7 h 27 m 5 sec
Reputation Power: 813

Hi,

Assuming you use a PL/pgSQL function, you'd have to put this in the DECLARE part:

Code:

start_date timestamp := '2009-6-1';

Viewing: Dev Shed Forums > Databases > PostgreSQL Help > How to Declare DateTime

Developer Shed Advertisers and Affiliates

Thread Tools	Search this Thread
Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode	Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts vB code is On Smilies are On [IMG] code is On HTML code is Off

Forum Jump